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
