Hi
I was trying to create an external table named "adclicktable"  by API "def 
createExternalTable(tableName: String, path: String)",then I can get the schema 
of this table successfully like below and this table can be queried 
normally.The data files are all Parquet files.
sqlContext.sql("describe adclicktable").collect
res3: Array[org.apache.spark.sql.Row] = Array([sy,int,], [cu,int,], [pj,int,], 
[pn,int,], [place,int,], [meterial,int,], [time,string,], [ip,string,], 
[uid,string,], [tags,string,], [url,string,], [ua,string,], [ucode,int,], 
[date,string,])
But I could not get the schema information from Hive CLI,like below:
hive> describe adclicktable;
OK
col                     array<string>           from deserializer 
Did I miss any configuration?


Zhang Xiongfei
Thanks

Reply via email to