Re: sql parser encoding

2015-03-19 Thread Venki Korukanti
How about replacing '台北' with _UTF16'台北' in your query? On Thu, Mar 19, 2015 at 2:44 AM, Wang Darrell darrellwan...@gmail.com wrote: there is still some encoding problem First I encoding '台北' into this '#21488;#21271;' then Drill has no problem with it then send the query to mongoDB. But

How do I make json files les painful

2015-03-19 Thread Jim Bates
I constantly, constantly, constantly hit this. I have json files that are just a huge collection of an array of json objects example MyArrayInTheFile: [{a:1,b:2,c:3},{a:1,b:2,c:3},...] My issue is in exploring the data, I hit this. Query failed: Query stopped., Record was too large to copy

Re: How do I make json files les painful

2015-03-19 Thread Matt
Is each file a single json array object? If so, would converting the files to a format with one line per record a potential solution? Example using jq (http://stedolan.github.io/jq/): jq -c '.[]' On 19 Mar 2015, at 12:22, Jim Bates wrote: I constantly, constantly, constantly hit this. I