[jira] [Commented] (TRAFODION-1278) LP Bug: 1465899 - Create table LIKE hive table fails silently
[ https://issues.apache.org/jira/browse/TRAFODION-1278?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15284906#comment-15284906 ] Anoop Sharma commented on TRAFODION-1278: - create like a hive table is not supported. But one can do: create table test_item no load as select * from hive.hive.item; This will create a traf table like hive.hive.item but not load data into it. One can also use 'primary key' clause during CTAS stmt to specify pkey columns for the tgt table. > LP Bug: 1465899 - Create table LIKE hive table fails silently > - > > Key: TRAFODION-1278 > URL: https://issues.apache.org/jira/browse/TRAFODION-1278 > Project: Apache Trafodion > Issue Type: Bug > Components: sql-general >Reporter: Barry Fritchman >Assignee: Qifan Chen >Priority: Critical > Fix For: 2.0-incubating > > > When using the CREATE TABLE LIKE syntax with a hive table as > , the statement appears to execute successfully, but the table is in > fact not created: > >>create table traf_orders like hive.hive.orders; > --- SQL operation complete. > >>invoke traf_orders; > *** ERROR[4082] Object TRAFODION.SEABASE.TRAF_ORDERS does not exist or is > inaccessible. > --- SQL operation failed with errors. > >> > The problem seems to occur only when a Hive table is the source. This > problem causes an error when attempting to update statistics for a hive table > using sampling, because the sample table is not created. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (TRAFODION-1278) LP Bug: 1465899 - Create table LIKE hive table fails silently
[ https://issues.apache.org/jira/browse/TRAFODION-1278?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15282972#comment-15282972 ] Barry Fritchman commented on TRAFODION-1278: Yes, I think so. The primary problem was that no error was given even though the statement failed, and that is no longer the case. Regarding the need for this to work to support Update Statistics on Hive tables, I'm working on a different approach that won't require it. > LP Bug: 1465899 - Create table LIKE hive table fails silently > - > > Key: TRAFODION-1278 > URL: https://issues.apache.org/jira/browse/TRAFODION-1278 > Project: Apache Trafodion > Issue Type: Bug > Components: sql-general >Reporter: Barry Fritchman >Assignee: Qifan Chen >Priority: Critical > Fix For: 2.0-incubating > > > When using the CREATE TABLE LIKE syntax with a hive table as > , the statement appears to execute successfully, but the table is in > fact not created: > >>create table traf_orders like hive.hive.orders; > --- SQL operation complete. > >>invoke traf_orders; > *** ERROR[4082] Object TRAFODION.SEABASE.TRAF_ORDERS does not exist or is > inaccessible. > --- SQL operation failed with errors. > >> > The problem seems to occur only when a Hive table is the source. This > problem causes an error when attempting to update statistics for a hive table > using sampling, because the sample table is not created. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (TRAFODION-1278) LP Bug: 1465899 - Create table LIKE hive table fails silently
[ https://issues.apache.org/jira/browse/TRAFODION-1278?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15282860#comment-15282860 ] liu ming commented on TRAFODION-1278: - With latest build and test: >>create table testit like hive.hive.item; *** ERROR[1010] The statement just entered is currently not supported. --- SQL operation failed with errors. >> So can we close this JIRA? > LP Bug: 1465899 - Create table LIKE hive table fails silently > - > > Key: TRAFODION-1278 > URL: https://issues.apache.org/jira/browse/TRAFODION-1278 > Project: Apache Trafodion > Issue Type: Bug > Components: sql-general >Reporter: Barry Fritchman >Assignee: Qifan Chen >Priority: Critical > Fix For: 2.0-incubating > > > When using the CREATE TABLE LIKE syntax with a hive table as > , the statement appears to execute successfully, but the table is in > fact not created: > >>create table traf_orders like hive.hive.orders; > --- SQL operation complete. > >>invoke traf_orders; > *** ERROR[4082] Object TRAFODION.SEABASE.TRAF_ORDERS does not exist or is > inaccessible. > --- SQL operation failed with errors. > >> > The problem seems to occur only when a Hive table is the source. This > problem causes an error when attempting to update statistics for a hive table > using sampling, because the sample table is not created. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (TRAFODION-1278) LP Bug: 1465899 - Create table LIKE hive table fails silently
[ https://issues.apache.org/jira/browse/TRAFODION-1278?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14947739#comment-14947739 ] Suresh Subbiah commented on TRAFODION-1278: --- This may be resolved with Roberta & Qifan's recent work. > LP Bug: 1465899 - Create table LIKE hive table fails silently > - > > Key: TRAFODION-1278 > URL: https://issues.apache.org/jira/browse/TRAFODION-1278 > Project: Apache Trafodion > Issue Type: Bug > Components: sql-general >Reporter: Barry Fritchman >Assignee: Qifan Chen >Priority: Critical > Fix For: 2.0-incubating > > > When using the CREATE TABLE LIKE syntax with a hive table as > , the statement appears to execute successfully, but the table is in > fact not created: > >>create table traf_orders like hive.hive.orders; > --- SQL operation complete. > >>invoke traf_orders; > *** ERROR[4082] Object TRAFODION.SEABASE.TRAF_ORDERS does not exist or is > inaccessible. > --- SQL operation failed with errors. > >> > The problem seems to occur only when a Hive table is the source. This > problem causes an error when attempting to update statistics for a hive table > using sampling, because the sample table is not created. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
