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