New Contributor
Posts: 1
Registered: ‎08-10-2017

Impala Shell - weird outputs with JSON value in delimited mode.

[ Edited ]

Hi all,


I'm new to impala, just set up 10 node cluster(Impala Shell v2.8.0-cdh5.11.1 (3382c1c) built on Thu Jun 1 10:36:12 PDT 2017), and ran some queries and found out weird result in delimited mode.


1. impala-shell -q "select value from table where ..." (value field was created as STRING field.)
    results : {"k1":"v1"} <= this is expected.


2. impala-shell -q "select value from table where ..." -B
   results : "{""k1"":""v1""}" <= this is not expected.


Why does impala shell add "" on JSON value in delimited mode? How can I fix this? any suggestions?