hadoop - Presto query Array of Rows -


so have hive external table schema looks :

{ . . `x` string, `y` array<struct<age:string,cid:string,dmt:string>>, `z` string } 

so need query column(column "y") array of nested json, can see data of column "y" hive, data in column seems invisible presto, though presto knows schema of field, this:

array(row(age varchar,cid varchar,dmt varchar)) 

as can see presto knows field array of row.

notes:

1.the table hive external table.

2.i schema of field "y" using odbc driver, data empty, can see in hive : [{"age":"12","cid":"bx21hdg","dmt":"120"}]

3.presto queries hivemetastore schema.

4.table stored parquet format.

so how can see data in field "y" please?


Comments

Popular posts from this blog

php - Vagrant up error - Uncaught Reflection Exception: Class DOMDocument does not exist -

vue.js - Create hooks for automated testing -

Add new key value to json node in java -