I have a json file in HDFS named autom.json contains.
{
"company": [
{
"modelName": {
"name": "abc"
}
},
{
"modelName": {
"name": "xyz"
}
}
]
}
When i query
select t.company.`modelName` from hdfs.`autom.json` t ;
it gives result
{"name":"abc"}
However, The expected result was both entries.
{"name":"abc"}
{"name":"xyz"}
Even when I query
select t.company.`modelName` from hdfs.`autom.json` t where
t.company.`modelName`.`name`='xyz' ;
it does not find anything.- drill gives first result for repeated values Mohit Kaushik
- Re: drill gives first result for repeated values Tomer Shiran
- Re: drill gives first result for repeated values Abhishek Girish
- Re: drill gives first result for repeated values Steven Phillips
