Assigned
Status Update
No update yet.
Comments
ep...@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.
ab...@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.
dv...@google.com
Even Kurt's example linked above still requires you to write out 300 clauses for each column. Generating SQL really is the best option.
fe...@amd.corp-partner.google.com
We want something like:
SELECT * FROM
(
SELECT
category_name,
product_id
FROM
production.products p
INNER JOIN production.categories c
ON c.category_id = p.category_id
) t
PIVOT(
COUNT(product_id)
FOR category_name IN (
[Children Bicycles],
[Comfort Bicycles],
[Cruisers Bicycles],
[Cyclocross Bicycles],
[Electric Bikes],
[Mountain Bikes],
[Road Bikes])
) AS pivot_table;
SELECT * FROM
(
SELECT
category_name,
product_id
FROM
production.products p
INNER JOIN production.categories c
ON c.category_id = p.category_id
) t
PIVOT(
COUNT(product_id)
FOR category_name IN (
[Children Bicycles],
[Comfort Bicycles],
[Cruisers Bicycles],
[Cyclocross Bicycles],
[Electric Bikes],
[Mountain Bikes],
[Road Bikes])
) AS pivot_table;
dv...@google.com
Is there a progress on this issue? :)
fe...@amd.corp-partner.google.com
Any update regarding PIVOT functionality?
gi...@appspot.gserviceaccount.com
dj...@google.com
update!
ep...@google.com
not sure where to upvote so writing here instead. i would love this!
fe...@amd.corp-partner.google.com
Yes please!
Description
Chrome Version : 92.0.4515.98 (Official Build) beta (64-bit)
<b>URLs (if applicable) :</b>
<b>Other browsers tested:</b>
Add OK or FAIL, along with the version, after other browsers where you
<b>have tested this issue:</b>
Safari:
Firefox:
Edge:
<b>What steps will reproduce the problem?</b>
<b>(1)</b> set up crostini container
<b>(2)</b> build flashrom from here
<b>(3)</b> attach SF600 flash programmer via USB and have it passed through into crostini and plug the SF600 into an amd/majolica board with 16MByte SPI NOR flash; some other mainboard will likely work too
(4) use flashrom to write an image to the flash chip. i used this command line: sudo ./flashrom -p dediprog:voltage=1.8v -w ~/coreboot/build/coreboot.rom
<b>What is the expected result?</b>
Flashing the new image to the SPI flash works and it passes the verification step as well, like it does on some other computer.
<b>What happens instead?</b>
flashrom stops due to USB errors:
felix@penguin:~/flashrom$ sudo ./flashrom -p dediprog:voltage=1.8v -w ~/coreboot/build/coreboot.rom
flashrom v1.2-448-g35e8bf6 on Linux 5.4.119-14940-g3f09d7690fd7 (x86_64)
flashrom is free software, get the source code at
Using clock_gettime for delay loops (clk_id: 1, resolution: 1ns).
Setting voltage to 1800 mV
Using dediprog id SF000000.
Found Winbond flash chip "W25Q128.W" (16384 kB, SPI) on dediprog.
Reading old flash chip contents... done.
Erasing and writing flash chip... SPI bulk write failed, expected 512, got LIBUSB_ERROR_TIMEOUT!
Command Set LED 0x4 failed (LIBUSB_ERROR_TIMEOUT)!
Reading current flash chip contents... Command Set LED 0x2 failed (LIBUSB_ERROR_TIMEOUT)!
Command Read SPI Bulk failed, -7 LIBUSB_ERROR_TIMEOUT!
Command Set LED 0x4 failed (LIBUSB_ERROR_TIMEOUT)!
Can't read anymore! Aborting.
FAILED!
Uh oh. Erase/write failed. Checking if anything has changed.
Reading current flash chip contents... Command Set LED 0x2 failed (LIBUSB_ERROR_NO_DEVICE)!
Command Read SPI Bulk failed, -4 LIBUSB_ERROR_NO_DEVICE!
Command Set LED 0x4 failed (LIBUSB_ERROR_NO_DEVICE)!
Can't even read anymore!
Your flash chip is in an unknown state.
Please report this on IRC at
mail flashrom@flashrom.org, thanks!
Command Set SPI Voltage 0x0 failed!
dmesg inside crostini shows that the emulated(?) XHCI controller died:
[ 71.796578] xhci_hcd 0000:00:0c.0: xHCI host not responding to stop endpoint command.
[ 71.796956] xhci_hcd 0000:00:0c.0: USBSTS: EINT
[ 71.813614] xhci_hcd 0000:00:0c.0: Host halt failed, -110
[ 71.813714] xhci_hcd 0000:00:0c.0: xHCI host controller not responding, assume dead
[ 71.813848] xhci_hcd 0000:00:0c.0: HC died; cleaning up
[ 71.813950] usb 1-1: USB disconnect, device number 2
running dmesg on the host inside a crosh terminal window doesn't show any XHCI errors and the manage USB devices page in the settings app still shows the SF600-ISP USB device as passed through to crostini and only disappears when i unplug the USB cable.
<b>Please provide any additional information below. Attach a screenshot if</b>
<b>possible.</b>
Google Chrome 92.0.4515.98 (Official Build) beta (64-bit)
Revision 564abd8de2c05f45308eec14f9110a10aff40ad9-refs/branch-heads/4515@{#1501}
Platform 13982.51.0 (Official Build) beta-channel zork
Firmware Version Google_Ezkinil.13434.212.0
<b>For graphics-related bugs, please copy/paste the contents of the about:gpu</b>
<b>page at the end of this report.</b>