You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Chinna Rao Lalam (JIRA)" <ji...@apache.org> on 2011/08/22 15:23:29 UTC
[jira] [Commented] (HIVE-2399) when use "PARTITION"，can not execute select statement
[ https://issues.apache.org/jira/browse/HIVE-2399?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13088683#comment-13088683 ]
Chinna Rao Lalam commented on HIVE-2399:
----------------------------------------
This issue related to HIVE-2111. Pls check this issue for more information.
> when use "PARTITION"，can not execute select statement
> -----------------------------------------------------
>
> Key: HIVE-2399
> URL: https://issues.apache.org/jira/browse/HIVE-2399
> Project: Hive
> Issue Type: Bug
> Components: CLI
> Affects Versions: 0.7.0
> Environment: OS: Red Hat Enterprise Linux AS release 4 (Nahant Update 5)
> Hadoop: 0.20.2
> hive: 0.7.0
> Reporter: yue.zhang
>
> when add "PARTITION" to create table statment, select statement of bad form data is not good.
> create table statment
> ==========================
> CREATE TABLE pplive(
> ip STRING,
> n1 STRING,
> n2 STRING,
> log_date STRING,
> method STRING,
> uri STRING,
> version STRING,
> status STRING,
> flux STRING,
> n3 STRING,
> n4 STRING
> )
> PARTITIONED BY(path STRING)
> ROW FORMAT SERDE 'org.apache.hadoop.hive.contrib.serde2.RegexSerDe'
> WITH SERDEPROPERTIES (
> "input.regex" = "([^ ]+)\\s+([^ ]+)\\s+([^ ]+)\\s+\\[(.+)\\]\\s+\"([^ ]+)\\s+(.+)\\s(.+)\"\\s+([^ ]+)\\s+([^ ]+)\\s+\"([^ ]+)\"\\s+\"(.+)\"",
> "output.format.string" = "%1$s %2$s %3$s %4$s"
> ) ;
> hive.bb.txt
> ==========================
> Error line1.
> Error line2.
> Error line3.
> Load data
> ==========================
> LOAD DATA INPATH '/user/hive/warehouse/input/hive.bb.txt' OVERWRITE INTO TABLE pplive PARTITION(path='haha') ;
> cli comand
> ==========================
> > select * from pplive;
> Failed with exception java.io.IOException:java.lang.NullPointerException
> hive log error:
> ==========================
> 2011-08-22 15:54:19,451 WARN serde2.RegexSerDe (RegexSerDe.java:deserialize(180)) - 1 unmatched rows are found: Error line1.
> 2011-08-22 15:54:19,453 ERROR CliDriver (SessionState.java:printError(343)) - Failed with exception java.io.IOException:java.lang.NullPointerException
> java.io.IOException: java.lang.NullPointerException
> at org.apache.hadoop.hive.ql.exec.FetchTask.fetch(FetchTask.java:150)
> at org.apache.hadoop.hive.ql.Driver.getResults(Driver.java:1114)
> at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:187)
> at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:241)
> at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:456)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at org.apache.hadoop.util.RunJar.main(RunJar.java:156)
> Caused by: java.lang.NullPointerException
> at java.util.ArrayList.addAll(ArrayList.java:472)
> at org.apache.hadoop.hive.serde2.objectinspector.UnionStructObjectInspector.getStructFieldsDataAsList(UnionStructObjectInspector.java:144)
> at org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe.serialize(LazySimpleSerDe.java:357)
> at org.apache.hadoop.hive.ql.exec.FetchTask.fetch(FetchTask.java:142)
> ... 9 more
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira