Assigned
Status Update
No update yet.
Comments
ke...@teslacoilsw.com
Hello,
I understand your issue is that the upload using the Python libraries to GS buckets and loading a table to BigQuery is comparatively slower than the upload using the commands gsutil and bq. Please let me know if I have misunderstood.
Let me clarify that the comparision should be done this way: Python's blob.upload_from_file() vs gsutil command and Python's load_table_from_file() vs bq command. Once that is clear, I would like to ask you for the codes that you use so I can reproduce the situation myself and get further insights. Please remove all the personal information from your codes before sharing them.
I will wait for your response,
Manuel Alaman
Google Cloud Big Data Support Barcelona
I understand your issue is that the upload using the Python libraries to GS buckets and loading a table to BigQuery is comparatively slower than the upload using the commands gsutil and bq. Please let me know if I have misunderstood.
Let me clarify that the comparision should be done this way: Python's blob.upload_from_file() vs gsutil command and Python's load_table_from_file() vs bq command. Once that is clear, I would like to ask you for the codes that you use so I can reproduce the situation myself and get further insights. Please remove all the personal information from your codes before sharing them.
I will wait for your response,
Manuel Alaman
Google Cloud Big Data Support Barcelona
ra...@google.com
ba...@google.com
You are correct.
Attached python script will generate a test csv file and conduct the python client test. Please find and replace all occurrences of `UPDATE_THIS` text.
It also has the DDL query you'll need to use to create the BQ table before you run the script.
Additionally, it has the exact bq command you'll need to test the bq CLI utility against the same file.
I just tested again after creating this using python 3.6.9, google-cloud-bigquery 2.20.0, and BigQuery CLI 2.0.69 (most recent versions). I still see the same performance difference (~ 4MBps upload from the python client, vs ~70MBps upload for the same file to the same table using BigQuery CLI.
Let me know if you need anything else.
Attached python script will generate a test csv file and conduct the python client test. Please find and replace all occurrences of `UPDATE_THIS` text.
It also has the DDL query you'll need to use to create the BQ table before you run the script.
Additionally, it has the exact bq command you'll need to test the bq CLI utility against the same file.
I just tested again after creating this using python 3.6.9, google-cloud-bigquery 2.20.0, and BigQuery CLI 2.0.69 (most recent versions). I still see the same performance difference (~ 4MBps upload from the python client, vs ~70MBps upload for the same file to the same table using BigQuery CLI.
Let me know if you need anything else.
su...@google.com
wa...@gmail.com
Hey there any update on this?
de...@gmail.com
Hi Kevin,
We are still investigating the issue. At this point we obtained [1] for the script and [2] for the bq command, where the “Upload complete” was achieved in about 11 seconds.
Further updates will be published here.
[1]
2021-06-30 06:55:01,496 root test_uploads INFO: Beginning load job...
2021-06-30 06:57:08,662 root test_uploads INFO: Job ID: XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX
2021-06-30 06:57:08,662 root test_uploads INFO: BQ load job complete without error!
[2]
Upload complete.
Waiting on bqjob_XXXXXXXXXXXXXXXXX_XXXXXXXXXXXXXXXX_X ... (48s) Current status: DONE
We are still investigating the issue. At this point we obtained [1] for the script and [2] for the bq command, where the “Upload complete” was achieved in about 11 seconds.
Further updates will be published here.
[1]
2021-06-30 06:55:01,496 root test_uploads INFO: Beginning load job...
2021-06-30 06:57:08,662 root test_uploads INFO: Job ID: XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX
2021-06-30 06:57:08,662 root test_uploads INFO: BQ load job complete without error!
[2]
Upload complete.
Waiting on bqjob_XXXXXXXXXXXXXXXXX_XXXXXXXXXXXXXXXX_X ... (48s) Current status: DONE
wa...@gmail.com
Hi there, has there been any progress on this? Should I move this over to an Issue at https://github.com/googleapis/google-cloud-python ?
ra...@google.com
ab...@gmail.com
Since this is being investigated in github, having this issue also here seems like a duplicate. Let's close this and follow the fix on github.
wa...@gmail.com
+1, fully agree, can Google prioritize this?
ke...@gmail.com
Why ?
ma...@gmail.com
Comment has been deleted.
cr...@gmail.com
Using 3rd party launcher Niagara, when switching app via navigation gesture, tapping the selected application does not work intermittently. Also noticed that "Clear All" does not appear sometimes. this occurred after upgrading to latest security patch. Of all the things, this is the most annoying issue in my Pixel 8pro. User experience is very much affected and this is supposed to be Pixel's strength
th...@gmail.com
Experiencing a similar issue with Microsoft Launcher on Android 14 (OnePlus 9 Pro - feb 2024 security patch release).
Returning from an app to home via gesture is showing the wallpaper but the system somehow "hangs" for one second before displaying icons.
Tried other launchers, issue is the same.
Interestingly, showing all opened apps with the appropriate gesture, then clicking on the wallpaper instantly brings back icons.
seehttps://issuetracker.google.com/issues/296108449
Returning from an app to home via gesture is showing the wallpaper but the system somehow "hangs" for one second before displaying icons.
Tried other launchers, issue is the same.
Interestingly, showing all opened apps with the appropriate gesture, then clicking on the wallpaper instantly brings back icons.
see
ra...@google.com
Reply on
Thank you for reporting this issue. For us to further investigate this issue, please provide the following additional information:
Android build
Which Android build are you using? (e.g. UQ1A.240205.002)
Device used
Which device did you use to reproduce this issue?
Android bug report (to be captured after reproducing the issue)
For steps to capture a bug report, please refer:https://developer.android.com/studio/debug/bug-report#bugreportdevice
Alternate method
Navigate to “Developer options”, ensure “USB debugging” is enabled, then enable “Bug report shortcut”. Capture bug report by holding the power button and selecting the “Take bug report” option.
Note: Please upload the bug report to google drive and share the folder to android-bugreport@google.com, then share the link here.
Thank you for reporting this issue. For us to further investigate this issue, please provide the following additional information:
Android build
Which Android build are you using? (e.g. UQ1A.240205.002)
Device used
Which device did you use to reproduce this issue?
Android bug report (to be captured after reproducing the issue)
For steps to capture a bug report, please refer:
Alternate method
Navigate to “Developer options”, ensure “USB debugging” is enabled, then enable “Bug report shortcut”. Capture bug report by holding the power button and selecting the “Take bug report” option.
Note: Please upload the bug report to google drive and share the folder to android-bugreport@google.com, then share the link here.
lo...@gmail.com Restricted+
Restricted+
Comment has been deleted.
vi...@google.com
Please provide the requested information to proceed further. Unfortunately the issue will be closed within 7 days if there is no further update.
je...@gmail.com
This issue is still relevant. And I speak for a lot of Android users here.
I'm on android 14 on a Honor Magic6 Pro 8.0.0.194(C431E4R2P2) and this bug is plaguing everyone's life.
I had the same on my pixel 7 pro on android 14 and my fold 5 on android 14.
I'm on android 14 on a Honor Magic6 Pro 8.0.0.194(C431E4R2P2) and this bug is plaguing everyone's life.
I had the same on my pixel 7 pro on android 14 and my fold 5 on android 14.
vi...@google.com Restricted+
Restricted+
Comment has been deleted.
vi...@google.com
Reply on
Thank you for reporting this issue. For us to further investigate this issue, please provide the following additional information:
Android bug report (to be captured after reproducing the issue)
For steps to capture a bug report, please refer:https://developer.android.com/studio/debug/bug-report#bugreportdevice
Alternate method
Navigate to “Developer options”, ensure “USB debugging” is enabled, then enable “Bug report shortcut”. Capture bug report by holding the power button and selecting the “Take bug report” option.
Note: Please upload the bug report to google drive and share the folder to android-bugreport@google.com, then share the link here.
Thank you for reporting this issue. For us to further investigate this issue, please provide the following additional information:
Android bug report (to be captured after reproducing the issue)
For steps to capture a bug report, please refer:
Alternate method
Navigate to “Developer options”, ensure “USB debugging” is enabled, then enable “Bug report shortcut”. Capture bug report by holding the power button and selecting the “Take bug report” option.
Note: Please upload the bug report to google drive and share the folder to android-bugreport@google.com, then share the link here.
bb...@debea.si
This is a major issue on my OnePlus 12. Wtf why is this going on 2 years old?
vi...@google.com
ni...@gmail.com
Why is this issue left open for so long I can't understand, just keeps getting assigned. You guys keep asking for logs for no reason at all when you can reproduce this on every single Android device in market with any 3rd party launcher.
j....@gmail.com
I'm confused why this isn't resolved? It's a massive experience issue and has been open for years?
Description
This is not the case for the system launcher, which gets touch events immediately.
This is a problem for users as they will be in an app and swipe to the launcher then try to tap on another app to open, but nothing will happen
Steps to reproduce:
Enable Gesture Navigation and set a 3rd party launcher as the default launcher.
Place Calculator app on the dock
Open Calculator
Swipe to return to the launcher
Quickly tap Calculator
Note that Calculator does not open
For 3rd party launcher you can use any launcher on the Play Store such as Nova Launcher or a build of Launcher3 such as the one I have created here:
Repeat steps with Pixel Launcher (or system launcher for the device) and note that Calculator does open
The correct behavior is for 3rd party launchers to work as well as system launchers, tapping calculator quickly should open calculator.
This can be tested using ADB with commands along the lines of the following:
input tap 540 1980; sleep 5; input swipe 540 2280 540 1900 20; sleep .5; input tap 540 1980
With 540x1980 being the position of the Calculator app and 540,2280 to 540,1900 being a good swiping distance to trigger the gesture nav home action. This layout is visible in the video.
This affects several versions of Android including Android 12 and 13 DP1
Tested on Pixel 4 Android 13 TPP1.220114.016 and Pixel 6 SQ1D.220105.007
This is Gesture Nav (Framework Launcher3 SystemUI) issue
This issue is very easy to reproduce and a logcat/bugreport will not contain relevant information. But I have attached a bug report anyway.
Video with show taps enabled: