You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hawq.apache.org by "Michael Andre Pearce (IG) (JIRA)" <ji...@apache.org> on 2017/01/10 19:52:58 UTC
[jira] [Updated] (HAWQ-1265) Support Complex Hive Schema's
[ https://issues.apache.org/jira/browse/HAWQ-1265?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Michael Andre Pearce (IG) updated HAWQ-1265:
--------------------------------------------
Description:
Currently if in hive you have Avro or other formats, where the schema is complex, you cannot currently query the fields in the complex object via hcatalog/pxf integration.
In terms of Avro Schema - records, enums and complex arrays, do not work.
Hive fully supports this complex/object notation, as does many of the other SQL tools in the Hadoop eco-system (Spark, Impala, Drill).
These all seem to support the same styled solution of using dots for complex object/path negotiation:
SELECT schema.table.fieldA.nestedRecordFieldS FROM myavrotable;
was:
Currently if in hive you have Avro or other formats, where the schema is complex, you cannot currently query the fields in the complex object via hcatalog/pxf integration.
In terms of Avro Schema - records, enums and complex arrays, do not work.
Hive fully supports this complex/object notation, as does many of the other SQL tools in the Hadoop eco-system (Spark, Impala, Drill).
These all seem to support the same styled solution of using dots for complex object/path negation:
SELECT schema.table.fieldA.nestedRecordFieldS FROM myavrotable;
> Support Complex Hive Schema's
> -----------------------------
>
> Key: HAWQ-1265
> URL: https://issues.apache.org/jira/browse/HAWQ-1265
> Project: Apache HAWQ
> Issue Type: Improvement
> Components: Hcatalog, PXF
> Reporter: Michael Andre Pearce (IG)
> Assignee: Ed Espino
>
> Currently if in hive you have Avro or other formats, where the schema is complex, you cannot currently query the fields in the complex object via hcatalog/pxf integration.
> In terms of Avro Schema - records, enums and complex arrays, do not work.
> Hive fully supports this complex/object notation, as does many of the other SQL tools in the Hadoop eco-system (Spark, Impala, Drill).
> These all seem to support the same styled solution of using dots for complex object/path negotiation:
> SELECT schema.table.fieldA.nestedRecordFieldS FROM myavrotable;
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)