hive load error

[Kumar Jayapal <kj...@gmail.com>]

Hi,

I am trying to insert data into file from parquet table. with the following
command and getting this exception.


insert overwrite directory '/tmp/blo' ROW FORMAT DELIMITED FIELDS
TERMINATED BY ','  STORED AS AVRO select dwhse, dsdat, dreg_num, drn_num,
dscnr, dareq, datak, dmsgc from blok where fiscal_year=2008 and
fiscal_period=01 limit 10;



What wrong with this command when I execute i get this error.

2015-06-29 23:35:01,907 INFO org.apache.hadoop.hive.ql.log.PerfLogger:
</PERFLOG method=compile start=1435620901903 end=1435620901907 duration=4
from=org.apache.hadoop.hive.ql.Driver>
2015-06-29 23:35:01,907 INFO org.apache.hadoop.hive.ql.log.PerfLogger:
<PERFLOG method=releaseLocks from=org.apache.hadoop.hive.ql.Driver>
2015-06-29 23:35:01,907 INFO org.apache.hadoop.hive.ql.log.PerfLogger:
</PERFLOG method=releaseLocks start=1435620901907 end=1435620901907
duration=0 from=org.apache.hadoop.hive.ql.Driver>
2015-06-29 23:35:01,907 WARN
org.apache.hive.service.cli.thrift.ThriftCLIService: Error executing
statement:
org.apache.hive.service.cli.HiveSQLException: Error while compiling
statement: FAILED: ParseException line 1:46 cannot recognize input near
'ROW' 'FORMAT' 'DELIMITED' in select clause
        at
org.apache.hive.service.cli.operation.SQLOperation.prepare(SQLOperation.java:102)
        at
org.apache.hive.service.cli.operation.SQLOperation.run(SQLOperation.java:173)
        at
org.apache.hive.service.cli.session.HiveSessionImpl.runOperationWithLogCapture(HiveSessionImpl.java:715)
        at
org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementInternal(HiveSessionImpl.java:370)
        at
org.apache.hive.service.cli.session.HiveSessionImpl.executeStatementAsync(HiveSessionImpl.java:357)
        at
org.apache.hive.service.cli.CLIService.executeStatementAsync(CLIService.java:237)
        at
org.apache.hive.service.cli.thrift.ThriftCLIService.ExecuteStatement(ThriftCLIService.java:392)
        at
org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement.getResult(TCLIService.java:1373)
        at
org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement.getResult(TCLIService.java:1358)
        at
org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)
        at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39)
        at
org.apache.hive.service.auth.TSetIpAddressProcessor.process(TSetIpAddressProcessor.java:55)
        at
org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:244)
        at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
        at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
        at java.lang.Thread.run(Thread.java:745)






Thanks
Jay