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