[jira] [Updated] (DRILL-4102) Only one row found in a JSON document that contains multiple items.
[
https://issues.apache.org/jira/browse/DRILL-4102?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
aditya menon updated DRILL-4102:
Description:
I tried to analyse a JSON file that had the following (sample) structure:
{code:json}
{
"Key1": {
"htmltags": ""
},
"Key2": {
"htmltags": ""
},
"Key3": {
"htmltags": ""
}
}
{code}
(Apologies for the obfuscation, I am unable to publish the original dataset.
But the structure is exactly the same. Note especially how the keys and other
data points *differ* in some places, and remain identical in others.)
When I run a {code:sql}SELECT * FROM DataFile.json{code} what I get is a single
row listed under three columns: {code:html}""{code} [i.e., only the entry
`Key1.htmltags`] .
Ideally, I should see three rows, each with entries from Key1..Key3, listed
under the correct respective column.
was:
I tried to analyse a JSON file that had the following (sample) structure:
{code:json}
{
"Key1": {
"htmltags": ""
},
"Key2": {
"htmltags": ""
},
"Key3": {
"htmltags": ""
}
}
{code}
(Apologies for the obfuscation, I am unable to publish the original dataset.
But the structure is exactly the same. Note especially how the keys and other
data points *differ* in some places, and remain identical in others.)
When I run a {code:sql}SELECT * FROM DataFile.son{code} what I get is a single
row listed under three columns: `""` [i.e., only the entry
`Key1.htmltags`] .
Ideally, I should see three rows, each with entries from Key1..Key3, listed
under the correct respective column.
> Only one row found in a JSON document that contains multiple items.
> ---
>
> Key: DRILL-4102
> URL: https://issues.apache.org/jira/browse/DRILL-4102
> Project: Apache Drill
> Issue Type: Bug
> Environment: OS X, Drill embedded, v1.1.0 installed via HomeBrew
>Reporter: aditya menon
>
> I tried to analyse a JSON file that had the following (sample) structure:
> {code:json}
> {
> "Key1": {
> "htmltags": " attr3='charlie' />"
> },
> "Key2": {
> "htmltags": " attr3='mike' />"
> },
> "Key3": {
> "htmltags": " />"
> }
> }
> {code}
> (Apologies for the obfuscation, I am unable to publish the original dataset.
> But the structure is exactly the same. Note especially how the keys and other
> data points *differ* in some places, and remain identical in others.)
> When I run a {code:sql}SELECT * FROM DataFile.json{code} what I get is a
> single row listed under three columns: {code:html}" />"{code} [i.e., only the
> entry `Key1.htmltags`] .
> Ideally, I should see three rows, each with entries from Key1..Key3, listed
> under the correct respective column.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Updated] (DRILL-4102) Only one row found in a JSON document that contains multiple items.
[
https://issues.apache.org/jira/browse/DRILL-4102?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
aditya menon updated DRILL-4102:
Description:
I tried to analyse a JSON file that had the following (sample) structure:
{code:json}
{
"Key1": {
"htmltags": ""
},
"Key2": {
"htmltags": ""
},
"Key3": {
"htmltags": ""
}
}
{code}
(Apologies for the obfuscation, I am unable to publish the original dataset.
But the structure is exactly the same. Note especially how the keys and other
data points *differ* in some places, and remain identical in others.)
When I run a {code:sql}SELECT * FROM DataFile.son{code} what I get is a single
row listed under three columns: `""` [i.e., only the entry
`Key1.htmltags`] .
Ideally, I should see three rows, each with entries from Key1..Key3, listed
under the correct respective column.
was:
I tried to analyse a JSON file that had the following (sample) structure:
{code:json}
{
"Key1": {
"htmltags": ""
},
"Key2": {
"htmltags": ""
},
"Key3": {
"htmltags": ""
}
}
{code}
(Apologies for the obfuscation, I am unable to publish the original dataset.
But the structure is exactly the same. Note especially how the keys and other
data points *differ* in some places, and remain identical in others.)
When I run a `SELECT * FROM DataFile.json` what I get is a single row listed
under three columns: `""` [i.e., only the entry `Key1.htmltags`] .
Ideally, I should see three rows, each with entries from Key1..Key3, listed
under the correct respective column.
> Only one row found in a JSON document that contains multiple items.
> ---
>
> Key: DRILL-4102
> URL: https://issues.apache.org/jira/browse/DRILL-4102
> Project: Apache Drill
> Issue Type: Bug
> Environment: OS X, Drill embedded, v1.1.0 installed via HomeBrew
>Reporter: aditya menon
>
> I tried to analyse a JSON file that had the following (sample) structure:
> {code:json}
> {
> "Key1": {
> "htmltags": " attr3='charlie' />"
> },
> "Key2": {
> "htmltags": " attr3='mike' />"
> },
> "Key3": {
> "htmltags": " />"
> }
> }
> {code}
> (Apologies for the obfuscation, I am unable to publish the original dataset.
> But the structure is exactly the same. Note especially how the keys and other
> data points *differ* in some places, and remain identical in others.)
> When I run a {code:sql}SELECT * FROM DataFile.son{code} what I get is a
> single row listed under three columns: `" attr2='delta' />"` [i.e., only the entry
> `Key1.htmltags`] .
> Ideally, I should see three rows, each with entries from Key1..Key3, listed
> under the correct respective column.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Updated] (DRILL-4102) Only one row found in a JSON document that contains multiple items.
[
https://issues.apache.org/jira/browse/DRILL-4102?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
aditya menon updated DRILL-4102:
Description:
I tried to analyse a JSON file that had the following (sample) structure:
{code:json}
{
"Key1": {
"htmltags": ""
},
"Key2": {
"htmltags": ""
},
"Key3": {
"htmltags": ""
}
}
{code}
(Apologies for the obfuscation, I am unable to publish the original dataset.
But the structure is exactly the same. Note especially how the keys and other
data points *differ* in some places, and remain identical in others.)
When I run a `SELECT * FROM DataFile.json` what I get is a single row listed
under three columns: `""` [i.e., only the entry `Key1.htmltags`] .
Ideally, I should see three rows, each with entries from Key1..Key3, listed
under the correct respective column.
was:
I tried to analyse a JSON file that had the following (sample) structure:
```
{
"Key1": {
"htmltags": ""
},
"Key2": {
"htmltags": ""
},
"Key3": {
"htmltags": ""
}
}
```
(Apologies for the obfuscation, I am unable to publish the original dataset.
But the structure is exactly the same. Note especially how the keys and other
data points *differ* in some places, and remain identical in others.)
When I run a `SELECT * FROM DataFile.json` what I get is a single row listed
under three columns: `""` [i.e., only the entry `Key1.htmltags`] .
Ideally, I should see three rows, each with entries from Key1..Key3, listed
under the correct respective column.
> Only one row found in a JSON document that contains multiple items.
> ---
>
> Key: DRILL-4102
> URL: https://issues.apache.org/jira/browse/DRILL-4102
> Project: Apache Drill
> Issue Type: Bug
> Environment: OS X, Drill embedded, v1.1.0 installed via HomeBrew
>Reporter: aditya menon
>
> I tried to analyse a JSON file that had the following (sample) structure:
> {code:json}
> {
> "Key1": {
> "htmltags": " attr3='charlie' />"
> },
> "Key2": {
> "htmltags": " attr3='mike' />"
> },
> "Key3": {
> "htmltags": " />"
> }
> }
> {code}
> (Apologies for the obfuscation, I am unable to publish the original dataset.
> But the structure is exactly the same. Note especially how the keys and other
> data points *differ* in some places, and remain identical in others.)
> When I run a `SELECT * FROM DataFile.json` what I get is a single row listed
> under three columns: `" />"` [i.e., only the entry `Key1.htmltags`] .
> Ideally, I should see three rows, each with entries from Key1..Key3, listed
> under the correct respective column.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
