hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "jone (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-4400) CLONE - hive 0.9.0 error query with store as sequence file format
Date Tue, 23 Apr 2013 16:07:16 GMT
jone created HIVE-4400:
--------------------------

             Summary: CLONE - hive 0.9.0 error query with store as sequence file format
                 Key: HIVE-4400
                 URL: https://issues.apache.org/jira/browse/HIVE-4400
             Project: Hive
          Issue Type: Bug
    Affects Versions: 0.9.0
            Reporter: jone


I create 2 table :

table page_view_1 store as text file and table page_view_2 store as squencefile. That has
error when run query in table page_view_2.

"CREATE TABLE page_view_1 (viewTime INT, userid BIGINT,page_url STRING, referrer_url STRING,ip
STRING COMMENT 'IP Address of the User') COMMENT 'This is the page view table' PARTITIONED
BY(dt STRING, country STRING);"

And 

"CREATE TABLE page_view_2 (viewTime INT, userid BIGINT,page_url STRING, referrer_url STRING,ip
STRING COMMENT 'IP Address of the User') COMMENT 'This is the page view table' PARTITIONED
BY(dt STRING, country STRING) STORED AS SEQUENCEFILE;"

then i run query in table page_view_2 "select count(*) from page_view_2" that has error

2013-04-23 10:08:52,808 FATAL org.apache.hadoop.mapred.Child: Error running child : java.lang.OutOfMemoryError:
Java heap space
	at org.apache.hadoop.mapred.MapTask$MapOutputBuffer.<init>(MapTask.java:949)
	at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:428)
	at org.apache.hadoop.mapred.MapTask.run(MapTask.java:372)
	at org.apache.hadoop.mapred.Child$4.run(Child.java:255)
	at java.security.AccessController.doPrivileged(Native Method)
	at javax.security.auth.Subject.doAs(Subject.java:396)
	at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1083)
	at org.apache.hadoop.mapred.Child.main(Child.java:249)

But then i run query with table page_view_1 "select count(*) from page_view_1" that has successful.

my hadoop version is : 1.0.0 and hive version is 0.9.0


--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message