emergingbytes.com Technology blog for data warehousing, business intelligence, iPhone Apps Development, Android Apps development and facebook applications

9Jun/170

Google BigQuery Group_Concat in Standard SQL

Google BigQuery provides a function (Group_Concat) to merge text in rows into one single row. It is an Aggregation Function and is supported in Legacy SQL.

It's equivalent in Standard SQL is String_Agg.

Tagged as: No Comments
   

Categories

Technology Forum

Tags

ADSL BO BO Mobile Business Intelligence Business Objects Business Objects Mobile CAST CDR COALESCE Database Delegate Data Foundation Layer Data Transfer Bytes DATE DAY DB DD Distinct Sessions DWH EXTRACT GPRS HOUR Information Design Tool INSERT INTERVAL MINUTE Mobile BI Mobile Business Intelligence MOD MSTR Mobile NULLIFZERO POSITION Pros Cons RANDOM SAP SAP BO Mobile SECOND SELECT SP SQL SUBSTR TOREFRESH UDF URL VALUES YYYY