Assigned
Status Update
No update yet.
Comments
ha...@unchartedpower.sg
ve...@google.com
is there any news on this?
ab...@google.com
You can pivot already, e.g. using a conditional aggregation: https://stackoverflow.com/questions/50796224/pivot-rows-in-big-query . Client tools such as Sheets, Excel, Data Studio, etc. are almost always in a better position to pivot the data returned by BigQuery since if you want to do it in a single BigQuery query, you need to provide the list of values and column names to pivot.
da...@google.com
I had to implement a solution to pivot 300 rows into columns. We need a better way to pivot rows. Conditional aggregation or sql generators are cumbersome and error-prone.
Description
<b>Chrome Version (from the about:version page):</b>96.0.4664.111
<b>Is this the most recent version:</b>yes
<b>OS + version:</b> Chromebook + Google Pixelbook Go
<b>CPU architecture (32-bit / 64-bit):</b>64-bit
<b>Window manager:</b>NIL
<b>URLs (if relevant):</b>
<b>Behavior in Linux Firefox:</b> NA
<b>Behavior in Windows Chrome (if you have access to it):</b> Normal
<b>What steps will reproduce the problem?</b>
<b>(1)</b> solving linux error: libva error: va_getDriverName() failed with unknown libva error,driver_name=(null)
<b>(2)</b>
<b>(3)</b>
<b>What is the expected result?</b> to launch application and detect plugged hardware
<b>What happens instead?</b> the application can launch but the hardware cannot be detected
<b>Please provide any additional information below. Attach a screenshot</b>
<b>and backtrace if possible.</b>
<b>For graphics-related bugs, please copy/paste the contents of the about:gpu</b>
<b>page at the end of this report.</b>