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 *
**
