[
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)
