Hello Shankar, >From the sample data you shared, it looks like you have JSON documents which differ considerably in the schema / structure. This isn't supported by default.
You could try turning on UNION type (an experimental feature). > set `exec.enable_union_type` = true; +-------+----------------------------------+ | ok | summary | +-------+----------------------------------+ | true | exec.enable_union_type updated. | +-------+----------------------------------+ 1 row selected (0.193 seconds) > select > `timestamp`, > sessionid, > gameid, > ajaxUrl, > ajaxData > from dfs.`/tmp/test1.json` t; +----------------+--------------------------------+----------------------------------------------------------------------------------------------+-----------------------+-----------+ | timestamp | sessionid | gameid | ajaxUrl | ajaxData | +----------------+--------------------------------+----------------------------------------------------------------------------------------------+-----------------------+-----------+ | 1457658600032 | BC497C7C39B3C90AC9E6E9E8194C3 | null | /player/updatebonus1 | null | | 1457771458873 | D18104E8CA3071C7A8F4E141B127 | https://daemon2.com/tournDetails.do?type=myGames&userId=1556148&jsonp_callback=jQuery213043 | [] | null | | 1457958600032 | BC497C7C39B3C90AC9E6E9E8194C3 | null | /player/updatebonus2 | null | +----------------+--------------------------------+----------------------------------------------------------------------------------------------+-----------------------+-----------+ 3 rows selected (0.36 seconds) Regards, Abhishek On Fri, Mar 18, 2016 at 12:02 PM, Shankar Mane <shankar.m...@games24x7.com> wrote: > Guys, > > > 1. I am stuck in the middle of somewhere. Could you please help me to > resolve below error. > 2. I am running query on drill 1.6.0 in cluster on logs json data (150GB > size of log file) ( 1 json / line). > > > I have just extract 3 lines from logs for test purpose. please find those > lines below. > > > -- ------------------------------------------- *test.json* > ------------------------------------------------- > > > > {"ajaxData":null,"metadata":null,"ajaxUrl":"/player/updatebonus1","selectedItem":null,"sessionid":"BC497C7C39B3C90AC9E6E9E8194C3","timestamp":1457658600032} > {"gameId":" > > https://daemon2.com/tournDetails.do?type=myGames&userId=1556148&jsonp_callback=jQuery213043 > ","ajaxData":null,"metadata":null,"ajaxUrl":[{"R":0,"rNo":1,"gid":4,"wal":0,"d":{"gid":4,"pt":3,"wc":2326,"top":"1","reg":true,"brkt":1457771400268,"sk":"25070010105301000009","id":56312439,"a":0,"st":1457771400000,"e":"0.0","j":0,"n":"Loot > Qualifier > > 1","tc":94,"et":0,"syst":1457771456,"rc":145770000,"s":5,"t":10000,"tk":false,"prnId":56311896,"jc":10000,"tp":"100000.0","ro":145400000,"rp":0,"isprn":false},"fl":"192.168.35.42","aaid":"5828"}],"selectedItem":null,"sessionid":"D18104E8CA3071C7A8F4E141B127","timestamp":1457771458873} > > {"ajaxData":null,"metadata":null,"ajaxUrl":"/player/updatebonus2","selectedItem":null,"sessionid":"BC497C7C39B3C90AC9E6E9E8194C3","timestamp":1457958600032} > > -- ------------------------------------------------ *Query* > -------------------------------------------- > > > select > `timestamp`, > sessionid, > gameid, > ajaxUrl, > ajaxData > from dfs.`/tmp/test.json` t > ; > > > > Error: DATA_READ ERROR: Error parsing JSON - You tried to start when you > are using a ValueWriter of type NullableVarCharWriterImpl. > > File /tmp/test.json > Record 2 > Fragment 0:0 >