About avinashjan06

avinashjan06 · ‎08-09-2017

Thanks @bpreachuk for the update. I am looking at a solution, which should automatically create table structure in Hive based on parquet files from cloudera. I.e I want a solution in Hortonworks which can perform like Impala

avinashjan06 · ‎08-08-2017

I transfered parquet file with snappy compression from cloudera system to hortonworks system. I want to load this file into Hive path /test/kpi Command using from Hive 2.0 CREATE EXTERNAL TABLE tbl_test like PARQUET '/test/kpi/part-r-00000-0c9d846a-c636-435d-990f-96f06af19cee.snappy.parquet' STORED AS PARQUET LOCATION '/test/kpi'; ERROR: × org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: ParseException line 1:44 cannot recognize input near 'PARQUET' ''/test/kpi/part-r-00000-0c9d846a-c636-435d-990f-96f06af19cee.snappy.parquet'' 'STORED' in table name

Online	Offline
Last Visited	‎08-09-2017 09:57 AM

Member Since	‎08-08-2017 12:56 PM
Last Visited	‎08-09-2017 09:57 AM
Posts	2

Cloudera Community

Re: parquet snappy file loading into hive

parquet snappy file loading into hive