原生JSON支持BigQuery? [英] Native JSON support for BigQuery?
问题描述
我正在考虑将hive数据(〜20T)迁移到Google BigQuery,
但Hive中的表格定义包含了BigQuery中不支持的map类型。
pre>
从data_repository中选择gid,payload ['src'];
尽管它可以通过使用正则表达式来解决。
<截至2012年10月1日,BigQuery支持换行符分隔的JSON用于导入和导出。
博客文章: http://googledevelopers.blogspot.com/2012 /10/got-big-json-bigquery-expands-data.html
数据格式文件: https://developers.google.com/bigquery/docs/import#dataformats
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.
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
这篇关于原生JSON支持BigQuery?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!