Drill doesn't support SELECT INTO syntax currently. You need to use Create Table As.
On Tue, Jun 28, 2016 at 11:30 PM, Omkar Pathallapalli <[email protected]> wrote: > Hi team, > > When i issued query in apache drill iam getting this error how can i > resolve this > > ERROR [HY000] [MapR][Drill] (1040) Drill failed to execute the query: > select distinct ani,calldate,count(distinct(did)) > Count_of_did,destcode,trffclass,sum(talktime)/60.mo_talktime,custcode into > rpttmp_final from dfs.tmp.r_fa_cdr_tmp where destcode not like > '%voicemail%' > and destcode not like '%customerservice%' and destcode not > like '%topup%' > group by ani,calldatetrffclass,destcode,custcode > > > [30027]Query execution error. Details:[ > PARSE ERROR: Encountered "into" at line 1, column 121. > Was expecting one of: > "FROM" ... > "," ... > "AS" ... > <IDENTIFIER> ... > <QUOTED_IDENTIFIER> ... > <BACK_QUOTED_IDENTIFIER> ... > <BRACKET_QUOTED_IDENTIFIER> ... > <UNICODE_QUOTED_IDENTIFIER> ... > "." ... > "[" ... > "(" ... > "NOT" ... > "IN" ... > "BETWEEN" ... > "LIKE" ... > "SIMILAR" ... > "=" ... > ">" ... > "<" ... > "<=" ... > ">=" ... > "<>" ... > "+" ... > "-" ... > "*" ... > "/" ... > "||" ... > ... > > > Regards, > omkar > >
