Hi, The output from your parquet file does not correspond to the JSON structure you have. In your parquet, the 'site' element is a map which contains one key "array". So does your flatten query look like
select flatten(d.site.array) from `data.parquet` d; or select flatten(d.site) from `data.parquet` d; (This would not work) - Rahul On Mon, Apr 27, 2015 at 4:28 AM, Vinupriyaa Muthusamypillai Ananthakrishna < [email protected]> wrote: > Json Structure was : > {"site": > [{"siteid":"site1","sitename":"sitename1"},{"siteid":"site2","sitename":"sitename2"}]} > > > Parquet data when i query through Drill explorer: > site as a column name: below is the value > { > "array" : [ { > "siteid" : "site1", > "sitename" : "sitename1" > }, { > "siteid" : "site2", > "sitename" : "sitename2" > } ] > } > > The work "array" is shown with the data. By which Drill is not able to > read the data set using the FLATTEN Function. > Is there any way to read the data using Flatten function. > > > Thanks > Vinupriyaa > >
