You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "ASF GitHub Bot (Jira)" <ji...@apache.org> on 2019/09/23 17:52:00 UTC
[jira] [Work logged] (HIVE-22209) Creating a materialized view with
no tables should be handled more gracefully
[ https://issues.apache.org/jira/browse/HIVE-22209?focusedWorklogId=316873&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-316873 ]
ASF GitHub Bot logged work on HIVE-22209:
-----------------------------------------
Author: ASF GitHub Bot
Created on: 23/Sep/19 17:51
Start Date: 23/Sep/19 17:51
Worklog Time Spent: 10m
Work Description: scarlin-cloudera commented on pull request #782: HIVE-22209: Graceful error msg when there is no table for a materiali…
URL: https://github.com/apache/hive/pull/782
…zed view.
A materialized view is not allowed to be created when there
is no table defined (e.g. select 5;). A graceful error msg
is now printed out rather than a stack trace.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Issue Time Tracking
-------------------
Worklog Id: (was: 316873)
Remaining Estimate: 0h
Time Spent: 10m
> Creating a materialized view with no tables should be handled more gracefully
> -----------------------------------------------------------------------------
>
> Key: HIVE-22209
> URL: https://issues.apache.org/jira/browse/HIVE-22209
> Project: Hive
> Issue Type: Bug
> Components: Materialized views
> Reporter: Jesus Camacho Rodriguez
> Assignee: Steve Carlin
> Priority: Minor
> Labels: pull-request-available
> Attachments: HIVE-22209.1.patch, HIVE-22209.patch
>
> Time Spent: 10m
> Remaining Estimate: 0h
>
> Currently, materialized views without a table reference are not supported. However, instead of printing a clear message about it, when a materialized view is created without a table reference, we fail with an unclear message.
> {code}
> > create materialized view mv_test1 as select 5;
> (...)
> ERROR : FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:Add request failed :
> INSERT INTO MV_TABLES_USED (MV_CREATION_METADATA_ID,TBL_ID) VALUES (?,?) )
> INFO : Completed executing command(queryId=hive_20190916203511_b609cccf-f5e3-45dd-abfd-6e869d94e39a); Time taken: 10.469 seconds
> Error: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaExcep
> tion(message:Add request failed : INSERT INTO MV_TABLES_USED (MV_CREATION_METADATA_ID,TBL_ID) VALUES (?,?) ) (state=08S01,code=1)
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)