[ 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