[ https://issues.apache.org/jira/browse/HIVE-4400?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
jone updated HIVE-4400: ----------------------- Issue Type: Test (was: Bug) > 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: Test > 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