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