hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "yue.zhang (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-2399) when use "PARTITION",can not execute select statement
Date Mon, 22 Aug 2011 08:02:29 GMT
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