Problem when converting hbase column into json

2015-08-11 Thread Parkavi Nandagopal
Hi Team, When I convert hbase column value into json using convert_from, getting wrong output. Hbase table :emp RowkeyCf:details 123 {abc:[3,2,34], def:[4,5,3]} 234 {efg:[34,4,2],hij:[3,45,5]} 0: jdbc:drill:> Select convert_fro

Null values in lists

2015-08-05 Thread Parkavi Nandagopal
Hi, How to use null values in list?? Even I changed `store.json.all_text_mode` = true also it is shouting same error. Query: select convert_from('{abc:[1,2],bvc:[3,4,null,3]}','json') from tab; Error: UNSUPPORTED_OPERATION ERROR: Null values are not supported in lists by default. Please set `

Split Function in Drill

2015-08-05 Thread Parkavi Nandagopal
Hi, Like Hive, Is there any split function available to split the string with special character? Thanks, Parkavi ::DISCLAIMER:: The contents of