Re: Question regarding CTAS Command

2016-11-17 Thread François Méthot
Here is a workaround to insert large *batch *of data, each batch insert is done on their own partition. create table hdfs.`/mytable/1` as (select) Later on, If you want to insert new batch of data to the same table: create table hdfs.`/mytable/2` as (select) Then when you query select

Re: Question regarding CTAS Command

2016-11-17 Thread Arina Yelchiyeva
Hi Sanjiv, currently Drill doesn't support insert or update of data in tables. Kind regards Arina On Thu, Nov 17, 2016 at 3:54 PM, Sanjiv Kumar wrote: > Hello > I have one doubt. In Drill we can create table using CTAS Command. > Like :- CREATE TABLE new_table_name AS ; > > As Mention

Question regarding CTAS Command

2016-11-17 Thread Sanjiv Kumar
Hello I have one doubt. In Drill we can create table using CTAS Command. Like :- CREATE TABLE new_table_name AS ; As Mention in official site:- http://drill.apache.org/docs/create-table-as-ctas-command/ My query is:- Is it possible to update or insert data in CTAS Created Table? -- Th