Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

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

Highlighted

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

New Contributor

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?