Native JSON support for BigQuery?

Question

Is there any plan for Google BigQuery to implement native JSON support?

I am considering migrating hive data (~20T) to Google BigQuery, but the table definitions in Hive contains map type which is not supported in BigQuery.

for example, the HiveQL below:

select gid, payload['src'] from data_repository;

although, it can be worked around by using regular expression.

Answer 1

As of 1 Oct 2012, BigQuery supports newline separated JSON for import and export.

Blog post: http://googledevelopers.blogspot.com/2012/10/got-big-json-bigquery-expands-data.html

Documentation on data formats: https://developers.google.com/bigquery/docs/import#dataformats