Hello Everyone, I'm running into the following Hive external table issue.


hive> CREATE EXTERNAL TABLE access(

     >       host STRING,

     >       identity STRING,

     >       user STRING,

     >       time STRING,

     >       request STRING,

     >       status STRING,

     >       size STRING,

     >       referer STRING,

     >       agent STRING)

     >       ROW FORMAT SERDE

'org.apache.hadoop.hive.contrib.serde2.RegexSerDe'

     >       WITH SERDEPROPERTIES (

     >      "input.regex" = "([^ ]*) ([^ ]*) ([^ ]*) (-|\\[[^\\]]*\\])

([^ \"]*|\"[^\"]*\") (-|[0-9]*) (-|[0-9]*)(?: ([^ \"]*|\"[^\"]*\") ([^
\"]*|\"[^\"]*\"))?",

     >       "output.format.string" = "%1$s %2$s %3$s %4$s %5$s %6$s

%7$s %8$s %9$s"

     >       )

     >       STORED AS TEXTFILE

     >       LOCATION

'/user/flume/events/request_logs/
ar1.vgs.mypoints.com/13-06-13/FlumeData.1371144648033';

FAILED: Error in metadata:

MetaException(message:hdfs://
h1.vgs.mypoints.com:8020/user/flume/events/request_logs/ar1.vgs.mypoints.com/13-06-13/FlumeData.1371144648033

is not a directory or unable to create one)

FAILED: Execution Error, return code 1 from
org.apache.hadoop.hive.ql.exec.DDLTask





In HDFS: file exists



hadoop fs -ls

/user/flume/events/request_logs/
ar1.vgs.mypoints.com/13-06-13/FlumeData.1371144648033

Found 1 items

-rw-r--r--   3 hdfs supergroup 2242037226 2013-06-13 11:14

/user/flume/events/request_logs/
ar1.vgs.mypoints.com/13-06-13/FlumeData.1371144648033



I've download the serde2 jar file too and install it in
/usr/lib/hive/lib/hive-json-serde-0.2.jar and I've bounced all the hadoop
services after that.



I even added the jar file manually in hive and run the above sql but still
failing.

ive> add jar /usr/lib/hive/lib/hive-json-serde-0.2.jar

     > ;

Added /usr/lib/hive/lib/hive-json-serde-0.2.jar to class path Added
resource: /usr/lib/hive/lib/hive-json-serde-0.2.jar



Any help would be highly appreciable.



-Sanjeev









-- 
Sanjeev Sagar

*"**Separate yourself from everything that separates you from others
!" - Nirankari
Baba Hardev Singh ji *

**

Reply via email to