[jira] [Commented] (DRILL-3534) Insert into table support

["John Omernik (JIRA)" <ji...@apache.org>]

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

John Omernik commented on DRILL-3534:
-------------------------------------

This would be a great feature to see in Drill as an "ETL Simplifier" 

Right now, there is a workaround, you can use CTAS to create tables of files. 

If you have a table say "MYDATA" and there directories for days below that (2017-08-10, 2017-08-11 etc)   What I typically do is 

CREATE TABLE `MYDATA/.2017-08-11` as Select ...

When the query is done, I use the filesystem (or hadoop) mv command to move those created files to their final destination. 

I don't like this method because it involves orchestration outside of Drill, where if Drill had a way to mimic this in a INSERT INTO statement, it would really make it easy on folks. 

Happy to answer questions or have more discussion here!

> Insert into table support
> -------------------------
>
>                 Key: DRILL-3534
>                 URL: https://issues.apache.org/jira/browse/DRILL-3534
>             Project: Apache Drill
>          Issue Type: New Feature
>            Reporter: Mehant Baid
>             Fix For: Future
>
>
> Umbrella JIRA to track the "Insert into table" feature. More details regarding the scope, design etc will follow as things start to materialize. 



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)