Hi i m trying to load data from a csv file into parquet in hive but got
this exception
hive> create table if not exists REGION( R_NAME string, R_REGIONKEY string,
R_COMMENT string ) stored as parquet;
OK
Time taken: 0.414 seconds
hive> load data local inpath
'file:///home/anubhav/Downloads/dbgen/region.tbl' into table region;
Loading data to table default.region
OK
Time taken: 1.011 seconds
hive> select * from region;
OK
Failed with exception java.io.IOException:java.lang.RuntimeException:
hdfs://localhost:54311/user/hive/warehouse/region/region.tbl is not a
Parquet file. expected magic number at tail [80, 65, 82, 49] but found
[115, 108, 124, 10]
Time taken: 0.108 seconds
can anyone help?hive version is 2.1
--
Thanks and Regards
* Anubhav Tarar *
* Software Consultant*
*Knoldus Software LLP <http://www.knoldus.com/home.knol> *
LinkedIn <http://in.linkedin.com/in/rahulforallp> Twitter
<https://twitter.com/RahulKu71223673> fb <rahulfora...@facebook.com>
mob : 8588915184
