Hi Parkavi, This might be a bug in the convert_from function (please log a bug). Try writing the same json to a file and it should work with all_text_mode set to true.
Parth On Wed, Aug 5, 2015 at 12:35 AM, Parkavi Nandagopal <[email protected]> wrote: > 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 `store.json.all_text_mode` to true to read lists > containing nulls. Be advised that this will treat JSON null values as a > string containing the word 'null'. > > Line 1 > Column 26 > Field bvc > Fragment 0:0 > > alter system set `store.json.all_text_mode` = true; > > +-------+------------------------------------+ > | ok | summary | > +-------+------------------------------------+ > | true | store.json.all_text_mode updated. | > +-------+------------------------------------+ > 1 row selected (0.079 seconds) > > 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 `store.json.all_text_mode` to true to read lists > containing nulls. Be advised that this will treat JSON null values as a > string containing the word 'null'. > > Line 1 > Column 26 > Field bvc > Fragment 0:0 > > [Error Id: 6c4477ea-a3ea-481a-ab4f-a764a1b57f2b on acesqcxen2:31010] > (state=,code=0) > > > ::DISCLAIMER:: > > ---------------------------------------------------------------------------------------------------------------------------------------------------- > > The contents of this e-mail and any attachment(s) are confidential and > intended for the named recipient(s) only. > E-mail transmission is not guaranteed to be secure or error-free as > information could be intercepted, corrupted, > lost, destroyed, arrive late or incomplete, or may contain viruses in > transmission. The e mail and its contents > (with or without referred errors) shall therefore not attach any liability > on the originator or HCL or its affiliates. > Views or opinions, if any, presented in this email are solely those of the > author and may not necessarily reflect the > views or opinions of HCL or its affiliates. Any form of reproduction, > dissemination, copying, disclosure, modification, > distribution and / or publication of this message without the prior > written consent of authorized representative of > HCL is strictly prohibited. If you have received this email in error > please delete it and notify the sender immediately. > Before opening any email and/or attachments, please check them for viruses > and other defects. > > > ---------------------------------------------------------------------------------------------------------------------------------------------------- >
