Link correction:
http://apache.github.io/drill/docs/json-data-model#handling-type-differences
Kristine Hahn
Sr. Technical Writer
415-497-8107 @krishahn
On Fri, Apr 3, 2015 at 6:57 AM, Vince Gonzalez
wrote:
> Yep:
>
> 0: jdbc:drill:zk=local> select jblob['v'] from (select
> convert_from(columns
That's right. columns[1] from tsv file is regarded as a VARCHAR column.
You have to use convert_from function.
0: jdbc:drill:zk=local> select t.colA.v from (select
convert_from(columns[1], 'JSON') from `AncestrySample100.tsv` limit 1) as
t(colA);
++
| EXPR$0 |
++
| 3.0
Yep:
0: jdbc:drill:zk=local> select jblob['v'] from (select
convert_from(columns[1], 'JSON') as jblob from `AncestrySample100.tsv`)
limit 1;
++
| EXPR$0 |
++
| 3.0|
++
1 row selected (0.136 seconds)
Thanks Carol!
On Fri, Apr 3, 2015 at 9:28 AM, Ca
maybe something like
select convert_from(t.columns[1], 'JSON') from AncestrySample100.tsv t
On Fri, Apr 3, 2015 at 9:06 AM, Vince Gonzalez
wrote:
> Can I tell Drill to parse the JSON in a column of a TSV?
>
> cd /tmp
> curl -L --output AncestrySample100.tsv
>
> https://raw.githubusercontent.com
Can I tell Drill to parse the JSON in a column of a TSV?
cd /tmp
curl -L --output AncestrySample100.tsv
https://raw.githubusercontent.com/ThinkBigAnalytics/ThinkBigChallenge2014/master/data/AncestrySample100
...
0: jdbc:drill:zk=local> use dfs.tmp;
0: jdbc:drill:zk=local> select columns[1] from