When i run a the following query i get this error: Error: Unexpected. Please try again. It only happened when i run a query that return a timestamp and a column name "profile" and only if i try to insert the result into a Destination Table.
SELECT 'helllo' as [profile],
TIMESTAMP( '2014-10-22' ) as date_out
i have tried to change the column name from "profile" to something else and it works, but i really need it to be profile...
I see the expected result when I try your query with "allowLargeResults" disabled, both in the web UI and with the 'bq' command-line tool:
+---------+---------------------+
| profile | date_out |
+---------+---------------------+
| helllo | 2014-10-22 00:00:00 |
+---------+---------------------+
If "allowLargeResults" is enabled, however, this produces an internal error. This is a bug in BigQuery, and I've filed against the team. Is it possible for you to work around the issue by disabling allowLargeResults?
