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