hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Namit Jain (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (HIVE-3908) create view statement's outputs contains the view and a temporary dir.
Date Thu, 17 Jan 2013 06:48:23 GMT

    [ https://issues.apache.org/jira/browse/HIVE-3908?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13555916#comment-13555916
] 

Namit Jain edited comment on HIVE-3908 at 1/17/13 6:47 AM:
-----------------------------------------------------------

~/hive/hive_commit3/build/dist/bin$ ./hive
Logging initialized using configuration in jar:file:/Users/njain/hive/hive_commit3/build/dist/lib/hive-common-0.11.0-SNAPSHOT.jar!/hive-log4j.properties
Hive history file=/tmp/njain/hive_job_log_njain_201301171210_1882377220.txt
hive> set hive.exec.post.hooks=org.apache.hadoop.hive.ql.hooks.PostExecutePrinter;
hive> CREATE VIEW view1 AS SELECT value FROM src WHERE key=86;                    
FAILED: Error in metadata: AlreadyExistsException(message:Table view1 already exists)
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask
hive> drop view view1;
POSTHOOK: query: drop view view1
POSTHOOK: type: DROPVIEW
POSTHOOK: Input: default@view1
POSTHOOK: Output: default@view1
OK
Time taken: 1.248 seconds
hive> CREATE VIEW view1 AS SELECT value FROM src WHERE key=86;
POSTHOOK: query: CREATE VIEW view1 AS SELECT value FROM src WHERE key=86
POSTHOOK: type: CREATEVIEW
POSTHOOK: Output: default@view1
POSTHOOK: Output: file:/tmp/njain/hive_2013-01-17_12-10-42_129_7725102253266073600/-mr-10000
OK
Time taken: 0.224 seconds
hive> 




This does not show up in the test output file, since the directory name is masked out.
For the above query, there should be only 1 output, the view. It should not contain the temporary
directory.
                
      was (Author: namit):
    ~/hive/hive_commit3/build/dist/bin$ ./hive
Logging initialized using configuration in jar:file:/Users/njain/hive/hive_commit3/build/dist/lib/hive-common-0.11.0-SNAPSHOT.jar!/hive-log4j.properties
Hive history file=/tmp/njain/hive_job_log_njain_201301171210_1882377220.txt
hive> set hive.exec.post.hooks=org.apache.hadoop.hive.ql.hooks.PostExecutePrinter;
hive> CREATE VIEW view1 AS SELECT value FROM src WHERE key=86;                    
FAILED: Error in metadata: AlreadyExistsException(message:Table view1 already exists)
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask
hive> drop view view1;
POSTHOOK: query: drop view view1
POSTHOOK: type: DROPVIEW
POSTHOOK: Input: default@view1
POSTHOOK: Output: default@view1
OK
Time taken: 1.248 seconds
hive> CREATE VIEW view1 AS SELECT value FROM src WHERE key=86;
POSTHOOK: query: CREATE VIEW view1 AS SELECT value FROM src WHERE key=86
POSTHOOK: type: CREATEVIEW
POSTHOOK: Output: default@view1
POSTHOOK: Output: file:/tmp/njain/hive_2013-01-17_12-10-42_129_7725102253266073600/-mr-10000
OK
Time taken: 0.224 seconds
hive> 




This does not show up in the ant file, since the directory name is masked out.
For the above query, there should be only 1 output, the view. It should not contain the temporary
directory.
                  
> create view statement's outputs contains the view and a temporary dir.
> ----------------------------------------------------------------------
>
>                 Key: HIVE-3908
>                 URL: https://issues.apache.org/jira/browse/HIVE-3908
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Namit Jain
>
> It should only contain the view

--
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