question Re: How do i export Hive columns values as JSON (file) in Support Questions

question Re: How do i export Hive columns values as JSON (file) in Support Questions https://community.cloudera.com/t5/Support-Questions/How-do-i-export-Hive-columns-values-as-JSON-file/m-p/80656#M4668 thanks guna. really appreciated with your quick response.  While trying the same, noted the following issues 1. if there are multiple columns to export, then each column is being separated by | symbol as well (along with comma), which was unable to remove2. the table data exported into multiple splits files, but the expected output is a single file.3. if any one of the tag values are null, which are not being shown in the output  do you have any thoughts on this? how to handle these issue? Thu, 04 Oct 2018 10:57:56 GMT Sethurajan 2018-10-04T10:57:56Z