hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chinna Rao Lalam (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-2399) when use "PARTITION",can not execute select statement
Date Mon, 22 Aug 2011 13:23:29 GMT

    [ 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

       

Mime
View raw message