[
https://issues.apache.org/jira/browse/HIVE-2399?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13090842#comment-13090842
]
yue.zhang commented on HIVE-2399:
---------------------------------
An alternative solution is ： "select * from tablename where t.time is not null"
ps. In my usage scenarios,t.time is not null
> 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
