[jira] [Issue Comment Deleted] (DRILL-5298) CTAS with 0 records from a SELECT query should create the table with metadata
[ https://issues.apache.org/jira/browse/DRILL-5298?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Senthilkumar updated DRILL-5298: Comment: was deleted (was: The issue has not been fixed still. Table is not created on the event on empty dataset from a Hive Table) > CTAS with 0 records from a SELECT query should create the table with metadata > - > > Key: DRILL-5298 > URL: https://issues.apache.org/jira/browse/DRILL-5298 > Project: Apache Drill > Issue Type: Bug > Components: Metadata, Query Planning & Optimization, SQL Parser >Affects Versions: 1.9.0 > Environment: MapR 5.2 >Reporter: Senthilkumar > Fix For: 1.9.0 > > > Hello team, > I create a table in Drill using CTAS as > CREATE TABLE CTAS_TEST AS SELECT * FROM `hive.default`.`test` WHERE 1 = 0 > It runs successfully. > But the table is not getting created as there are 0 records getting returned > from the SELECT query. > CTAS should still go ahead and create the table with the column metadata. > When BI tools fire up multi-pass queries, with CTAS in the first query, the > subsequent queries fail because of a missing table. > In databases like SQL Server, Postgres, CTAS will create the table, even if > the SELECT doesnt return any rows. -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Closed] (DRILL-5298) CTAS with 0 records from a SELECT query should create the table with metadata
[ https://issues.apache.org/jira/browse/DRILL-5298?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Senthilkumar closed DRILL-5298. --- Resolution: Duplicate > CTAS with 0 records from a SELECT query should create the table with metadata > - > > Key: DRILL-5298 > URL: https://issues.apache.org/jira/browse/DRILL-5298 > Project: Apache Drill > Issue Type: Bug > Components: Metadata, Query Planning & Optimization, SQL Parser >Affects Versions: 1.9.0 > Environment: MapR 5.2 >Reporter: Senthilkumar > Fix For: 1.9.0 > > > Hello team, > I create a table in Drill using CTAS as > CREATE TABLE CTAS_TEST AS SELECT * FROM `hive.default`.`test` WHERE 1 = 0 > It runs successfully. > But the table is not getting created as there are 0 records getting returned > from the SELECT query. > CTAS should still go ahead and create the table with the column metadata. > When BI tools fire up multi-pass queries, with CTAS in the first query, the > subsequent queries fail because of a missing table. > In databases like SQL Server, Postgres, CTAS will create the table, even if > the SELECT doesnt return any rows. -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Reopened] (DRILL-5298) CTAS with 0 records from a SELECT query should create the table with metadata
[ https://issues.apache.org/jira/browse/DRILL-5298?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Senthilkumar reopened DRILL-5298: - The issue has not been fixed still. Table is not created on the event on empty dataset from a Hive Table > CTAS with 0 records from a SELECT query should create the table with metadata > - > > Key: DRILL-5298 > URL: https://issues.apache.org/jira/browse/DRILL-5298 > Project: Apache Drill > Issue Type: Bug > Components: Metadata, Query Planning & Optimization >Affects Versions: 1.9.0 > Environment: MapR 5.2 >Reporter: Senthilkumar > Fix For: 1.9.0 > > > Hello team, > I create a table in Drill using CTAS as > CREATE TABLE CTAS_TEST AS SELECT * FROM `hive.default`.`test` WHERE 1 = 0 > It runs successfully. > But the table is not getting created as there are 0 records getting returned > from the SELECT query. > CTAS should still go ahead and create the table with the column metadata. > When BI tools fire up multi-pass queries, with CTAS in the first query, the > subsequent queries fail because of a missing table. > In databases like SQL Server, Postgres, CTAS will create the table, even if > the SELECT doesnt return any rows. -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Commented] (DRILL-5298) CTAS with 0 records from a SELECT query should create the table with metadata
[ https://issues.apache.org/jira/browse/DRILL-5298?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15885375#comment-15885375 ] Senthilkumar commented on DRILL-5298: - This issue exists in 1.9 still.. If you try the following statement CREATE TABLE CTAS_TEST AS SELECT * FROM `hive.default`.`test` WHERE 1 = 0 and then try with SELECT * FROM CTAS_TEST, it will still fail with NO TABLE exception. > CTAS with 0 records from a SELECT query should create the table with metadata > - > > Key: DRILL-5298 > URL: https://issues.apache.org/jira/browse/DRILL-5298 > Project: Apache Drill > Issue Type: Bug > Components: Metadata, Query Planning & Optimization >Affects Versions: 1.9.0 > Environment: MapR 5.2 >Reporter: Senthilkumar > Fix For: 1.9.0 > > > Hello team, > I create a table in Drill using CTAS as > CREATE TABLE CTAS_TEST AS SELECT * FROM `hive.default`.`test` WHERE 1 = 0 > It runs successfully. > But the table is not getting created as there are 0 records getting returned > from the SELECT query. > CTAS should still go ahead and create the table with the column metadata. > When BI tools fire up multi-pass queries, with CTAS in the first query, the > subsequent queries fail because of a missing table. > In databases like SQL Server, Postgres, CTAS will create the table, even if > the SELECT doesnt return any rows. -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Commented] (DRILL-5298) CTAS with 0 records from a SELECT query should create the table with metadata
[ https://issues.apache.org/jira/browse/DRILL-5298?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15885359#comment-15885359 ] Senthilkumar commented on DRILL-5298: - Khurram, I wanted to know if somebody is working on it already. > CTAS with 0 records from a SELECT query should create the table with metadata > - > > Key: DRILL-5298 > URL: https://issues.apache.org/jira/browse/DRILL-5298 > Project: Apache Drill > Issue Type: Bug > Components: Metadata, Query Planning & Optimization >Affects Versions: 1.9.0 > Environment: MapR 5.2 >Reporter: Senthilkumar > Fix For: 1.9.0 > > > Hello team, > I create a table in Drill using CTAS as > CREATE TABLE CTAS_TEST AS SELECT * FROM `hive.default`.`test` WHERE 1 = 0 > It runs successfully. > But the table is not getting created as there are 0 records getting returned > from the SELECT query. > CTAS should still go ahead and create the table with the column metadata. > When BI tools fire up multi-pass queries, with CTAS in the first query, the > subsequent queries fail because of a missing table. > In databases like SQL Server, Postgres, CTAS will create the table, even if > the SELECT doesnt return any rows. -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Created] (DRILL-5298) CTAS with 0 records from a SELECT query should create the table with metadata
Senthilkumar created DRILL-5298: --- Summary: CTAS with 0 records from a SELECT query should create the table with metadata Key: DRILL-5298 URL: https://issues.apache.org/jira/browse/DRILL-5298 Project: Apache Drill Issue Type: Bug Components: Metadata, Query Planning & Optimization Affects Versions: 1.9.0 Environment: MapR 5.2 Reporter: Senthilkumar Fix For: 1.9.0 Hello team, I create a table in Drill using CTAS as CREATE TABLE CTAS_TEST AS SELECT * FROM `hive.default`.`test` WHERE 1 = 0 It runs successfully. But the table is not getting created as there are 0 records getting returned from the SELECT query. CTAS should still go ahead and create the table with the column metadata. When BI tools fire up multi-pass queries, with CTAS in the first query, the subsequent queries fail because of a missing table. In databases like SQL Server, Postgres, CTAS will create the table, even if the SELECT doesnt return any rows. -- This message was sent by Atlassian JIRA (v6.3.15#6346)