You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Namit Jain (JIRA)" <ji...@apache.org> on 2013/01/17 07:48:23 UTC
[jira] [Comment Edited] (HIVE-3908) create view statement's outputs
contains the view and a temporary dir.
[ 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