[jira] [Updated] (DRILL-6390) UnsupportedOperationException: Unable to get holder type for minor type [LATE] and mode [OPTIONAL]
[
https://issues.apache.org/jira/browse/DRILL-6390?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Trung Ta updated DRILL-6390:
Description:
I tried this query on some of our JSON files that are stored in a S3 Bucket, in
which I tried to convert JSON objects (application, application_fee) into
varchar:
{code:java}
SELECT
CONCAT(
'"', CONVERT_TO(_stg.data.application_fee, 'JSON'), '"'
, ',', '"', CONVERT_TO(_stg.data.application_fee, 'JSON'), '"'
) as JSONs
FROM (
SELECT
flatten(js.data) AS data
FROM
s3_bucket.`` AS js
) _stg
{code}
On some of the datasets the query failed and I got this error message
{quote}org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR:
UnsupportedOperationException: Unable to get holder type for minor type [LATE]
and mode [OPTIONAL] Fragment 0:0 [Error Id: 5e74e125-de22-46fa-8d31-233d0fc40140
{quote}
The dataset, on which the query failed looks like following:
{code:java}
{
"data":
[
{
"application": null,
"application_fee": null,
"amount": 1
},
{
"application":
{
"id": "some_id",
"name": "Some App",
"object": "application"
},
"application_fee": null,
"amount": 5
}
],
"has_more": false,
"object": "list",
"url": "/v1/charges"
}
{code}
I ran some further tests on the query and found out that the query only fails
at object "application_fee", which is null in both arrays of object "data".
Which might explain why I never ran into this error in the other datasets (no
object arrays there are null).
was:
I tried this query on some of our JSON files that are stored in a S3 Bucket, in
which I tried to convert JSON objects (application, application_fee) into
varchar:
{quote}SELECT
CONCAT(
'"', CONVERT_TO(_stg.data.application_fee, 'JSON'), '"'
, ',', '"', CONVERT_TO(_stg.data.application_fee, 'JSON'), '"'
) as JSONs
FROM (
SELECT
flatten(js.data) AS data
FROM
s3_bucket.`` AS js
) _stg
{quote}
On some of the datasets the query failed and I got this error message
{quote}org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR:
UnsupportedOperationException: Unable to get holder type for minor type [LATE]
and mode [OPTIONAL] Fragment 0:0 [Error Id: 5e74e125-de22-46fa-8d31-233d0fc40140
{quote}
The dataset, on which the query failed looks like following:
{code:java}
{
"data":
[
{
"application": null,
"application_fee": null,
"amount": 1
},
{
"application":
{
"id": "some_id",
"name": "Some App",
"object": "application"
},
"application_fee": null,
"amount": 5
}
],
"has_more": false,
"object": "list",
"url": "/v1/charges"
}
{code}
I ran some further tests on the query and found out that the query only fails
at object "application_fee", which is null in both arrays of object "data".
Which might explain why I never ran into this error in the other datasets (no
object arrays there are null).
> UnsupportedOperationException: Unable to get holder type for minor type
> [LATE] and mode [OPTIONAL]
> --
>
> Key: DRILL-6390
> URL: https://issues.apache.org/jira/browse/DRILL-6390
> Project: Apache Drill
> Issue Type: Bug
> Components: Execution - Data Types, Storage - JSON
>Affects Versions: 1.11.0
>Reporter: Trung Ta
>Priority: Major
>
> I tried this query on some of our JSON files that are stored in a S3 Bucket,
> in which I tried to convert JSON objects (application, application_fee) into
> varchar:
> {code:java}
> SELECT
> CONCAT(
> '"', CONVERT_TO(_stg.data.application_fee, 'JSON'), '"'
> , ',', '"', CONVERT_TO(_stg.data.application_fee, 'JSON'), '"'
> ) as JSONs
> FROM (
> SELECT
> flatten(js.data) AS data
> FROM
> s3_bucket.`` AS js
> ) _stg
> {code}
> On some of the datasets the query failed and I got this error message
> {quote}org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR:
> UnsupportedOperationException: Unable to get holder type for minor type
> [LATE] and mode [OPTIONAL] Fragment 0:0 [Error Id:
> 5e74e125-de22-46fa-8d31-233d0fc40140
> {quote}
> The dataset, on which the query failed looks like following:
>
[jira] [Updated] (DRILL-6390) UnsupportedOperationException: Unable to get holder type for minor type [LATE] and mode [OPTIONAL]
[
https://issues.apache.org/jira/browse/DRILL-6390?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Trung Ta updated DRILL-6390:
Description:
I tried this query on some of our JSON files that are stored in a S3 Bucket, in
which I tried to convert JSON objects (application, application_fee) into
varchar:
{quote}SELECT
CONCAT(
'"', CONVERT_TO(_stg.data.application_fee, 'JSON'), '"'
, ',', '"', CONVERT_TO(_stg.data.application_fee, 'JSON'), '"'
) as JSONs
FROM (
SELECT
flatten(js.data) AS data
FROM
s3_bucket.`` AS js
) _stg
{quote}
On some of the datasets the query failed and I got this error message
{quote}org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR:
UnsupportedOperationException: Unable to get holder type for minor type [LATE]
and mode [OPTIONAL] Fragment 0:0 [Error Id: 5e74e125-de22-46fa-8d31-233d0fc40140
{quote}
The dataset, on which the query failed looks like following:
"data":
[
{
"application": null,
"application_fee": null,
"amount": 1
},
{
"application":
{
"id": "some_id",
"name": "Some App",
"object": "application"
},
"application_fee": null,
"amount": 5
}
],
"has_more": false,
"object": "list",
"url": "/v1/charges"
}
I ran some further tests on the query and found out that the query only fails
at object "application_fee", which is null in both arrays of object "data".
Which might explain why I never ran into this error in the other datasets (no
object arrays there are null).
was:
I tried this query on some of our JSON files that are stored in a S3 Bucket, in
which I tried to convert JSON objects (application, application_fee) into
varchar:
{quote}SELECT
CONCAT(
'"', CONVERT_TO(_stg.data.application_fee, 'JSON'), '"'
, ',', '"', CONVERT_TO(_stg.data.application_fee, 'JSON'), '"'
) as JSONs
FROM (
SELECT
flatten(js.data) AS data
FROM
s3_bucket.`` AS js
) _stg
{quote}
On some of the datasets the query failed and I got this error message
{quote}org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR:
UnsupportedOperationException: Unable to get holder type for minor type [LATE]
and mode [OPTIONAL] Fragment 0:0 [Error Id: 5e74e125-de22-46fa-8d31-233d0fc40140
{quote}
The dataset, on which the query failed looks like following:
{
"data":
[
{
"application": null,
"application_fee": null,
"amount": 1
},
{
"application":
{
"id": "some_id",
"name": "Some App",
"object": "application"
},
"application_fee": null,
"amount": 5
}
],
"has_more": false,
"object": "list",
"url": "/v1/charges"
}
I ran some further tests on the query and found out that the query only fails
at object "application_fee", which is null in both arrays of object "data".
Which might explain why I never ran into this error in the other datasets (no
object arrays there are null).
> UnsupportedOperationException: Unable to get holder type for minor type
> [LATE] and mode [OPTIONAL]
> --
>
> Key: DRILL-6390
> URL: https://issues.apache.org/jira/browse/DRILL-6390
> Project: Apache Drill
> Issue Type: Bug
> Components: Execution - Data Types, Storage - JSON
>Affects Versions: 1.11.0
>Reporter: Trung Ta
>Priority: Major
>
> I tried this query on some of our JSON files that are stored in a S3 Bucket,
> in which I tried to convert JSON objects (application, application_fee) into
> varchar:
> {quote}SELECT
> CONCAT(
> '"', CONVERT_TO(_stg.data.application_fee, 'JSON'), '"'
> , ',', '"', CONVERT_TO(_stg.data.application_fee, 'JSON'), '"'
> ) as JSONs
> FROM (
> SELECT
> flatten(js.data) AS data
> FROM
> s3_bucket.`` AS js
> ) _stg
> {quote}
> On some of the datasets the query failed and I got this error message
> {quote}org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR:
> UnsupportedOperationException: Unable to get holder type for minor type
> [LATE] and mode [OPTIONAL] Fragment 0:0 [Error Id:
> 5e74e125-de22-46fa-8d31-233d0fc40140
> {quote}
> The dataset, on which the query failed looks like following:
> "data":
> [
> {
> "application": null,
> "application_fee": null,
> "amount": 1
> },
> {
> "application":
> {
> "id": "some_id",
> "name": "Some App",
> "object": "application"
> },
> "application_fee": null,
> "amount": 5
> }
> ],
> "has_more": false,
> "object": "list",
> "url": "/v1/charges"
> }
> I ran some further tests on the query and found out that the query only fails
> at object "application_fee", which is null in both arrays of object "data".
> Which might explain why I never ran
[jira] [Updated] (DRILL-6390) UnsupportedOperationException: Unable to get holder type for minor type [LATE] and mode [OPTIONAL]
[
https://issues.apache.org/jira/browse/DRILL-6390?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Trung Ta updated DRILL-6390:
Description:
I tried this query on some of our JSON files that are stored in a S3 Bucket, in
which I tried to convert JSON objects (application, application_fee) into
varchar:
{quote}SELECT
CONCAT(
'"', CONVERT_TO(_stg.data.application_fee, 'JSON'), '"'
, ',', '"', CONVERT_TO(_stg.data.application_fee, 'JSON'), '"'
) as JSONs
FROM (
SELECT
flatten(js.data) AS data
FROM
s3_bucket.`` AS js
) _stg
{quote}
On some of the datasets the query failed and I got this error message
{quote}org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR:
UnsupportedOperationException: Unable to get holder type for minor type [LATE]
and mode [OPTIONAL] Fragment 0:0 [Error Id: 5e74e125-de22-46fa-8d31-233d0fc40140
{quote}
The dataset, on which the query failed looks like following:
bq. "data":
bq. [
bq. {
bq. "application": null,
bq. "application_fee": null,
bq. "amount": 1
bq. },
bq. {
bq. "application":
bq. {
bq. "id": "some_id",
bq. "name": "Some App",
bq. "object": "application"
bq. },
bq. "application_fee": null,
bq. "amount": 5
bq. }
bq. ],
bq. "has_more": false,
bq. "object": "list",
bq. "url": "/v1/charges"
bq. }
I ran some further tests on the query and found out that the query only fails
at object "application_fee", which is null in both arrays of object "data".
Which might explain why I never ran into this error in the other datasets (no
object arrays there are null).
was:
I tried this query on some of our JSON files that are stored in a S3 Bucket, in
which I tried to convert JSON objects (application, application_fee) into
varchar:
{quote}SELECT
CONCAT(
'"', CONVERT_TO(_stg.data.application_fee, 'JSON'), '"'
, ',', '"', CONVERT_TO(_stg.data.application_fee, 'JSON'), '"'
) as JSONs
FROM (
SELECT
flatten(js.data) AS data
FROM
s3_bucket.`` AS js
) _stg
{quote}
On some of the datasets the query failed and I got this error message
{quote}org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR:
UnsupportedOperationException: Unable to get holder type for minor type [LATE]
and mode [OPTIONAL] Fragment 0:0 [Error Id: 5e74e125-de22-46fa-8d31-233d0fc40140
{quote}
The dataset, on which the query failed looks like following:
"data":
[
{
"application": null,
"application_fee": null,
"amount": 1
},
{
"application":
{
"id": "some_id",
"name": "Some App",
"object": "application"
},
"application_fee": null,
"amount": 5
}
],
"has_more": false,
"object": "list",
"url": "/v1/charges"
}
I ran some further tests on the query and found out that the query only fails
at object "application_fee", which is null in both arrays of object "data".
Which might explain why I never ran into this error in the other datasets (no
object arrays there are null).
> UnsupportedOperationException: Unable to get holder type for minor type
> [LATE] and mode [OPTIONAL]
> --
>
> Key: DRILL-6390
> URL: https://issues.apache.org/jira/browse/DRILL-6390
> Project: Apache Drill
> Issue Type: Bug
> Components: Execution - Data Types, Storage - JSON
>Affects Versions: 1.11.0
>Reporter: Trung Ta
>Priority: Major
>
> I tried this query on some of our JSON files that are stored in a S3 Bucket,
> in which I tried to convert JSON objects (application, application_fee) into
> varchar:
> {quote}SELECT
> CONCAT(
> '"', CONVERT_TO(_stg.data.application_fee, 'JSON'), '"'
> , ',', '"', CONVERT_TO(_stg.data.application_fee, 'JSON'), '"'
> ) as JSONs
> FROM (
> SELECT
> flatten(js.data) AS data
> FROM
> s3_bucket.`` AS js
> ) _stg
> {quote}
> On some of the datasets the query failed and I got this error message
> {quote}org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR:
> UnsupportedOperationException: Unable to get holder type for minor type
> [LATE] and mode [OPTIONAL] Fragment 0:0 [Error Id:
> 5e74e125-de22-46fa-8d31-233d0fc40140
> {quote}
> The dataset, on which the query failed looks like following:
> bq. "data":
> bq. [
> bq. {
> bq. "application": null,
> bq. "application_fee": null,
> bq. "amount": 1
> bq. },
> bq. {
> bq. "application":
> bq. {
> bq. "id": "some_id",
> bq. "name": "Some App",
> bq. "object": "application"
> bq. },
> bq. "application_fee": null,
> bq. "amount": 5
> bq. }
> bq. ],
> bq. "has_more": false,
> bq. "object": "list",
> bq. "url": "/v1/charges"
> bq. }
> I ran some further tests on the query and found out that the query only fails
> at object
[jira] [Updated] (DRILL-6390) UnsupportedOperationException: Unable to get holder type for minor type [LATE] and mode [OPTIONAL]
[
https://issues.apache.org/jira/browse/DRILL-6390?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Trung Ta updated DRILL-6390:
Description:
I tried this query on some of our JSON files that are stored in a S3 Bucket, in
which I tried to convert JSON objects (application, application_fee) into
varchar:
{quote}SELECT
CONCAT(
'"', CONVERT_TO(_stg.data.application_fee, 'JSON'), '"'
, ',', '"', CONVERT_TO(_stg.data.application_fee, 'JSON'), '"'
) as JSONs
FROM (
SELECT
flatten(js.data) AS data
FROM
s3_bucket.`` AS js
) _stg
{quote}
On some of the datasets the query failed and I got this error message
{quote}org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR:
UnsupportedOperationException: Unable to get holder type for minor type [LATE]
and mode [OPTIONAL] Fragment 0:0 [Error Id: 5e74e125-de22-46fa-8d31-233d0fc40140
{quote}
The dataset, on which the query failed looks like following:
{code:java}
{
"data":
[
{
"application": null,
"application_fee": null,
"amount": 1
},
{
"application":
{
"id": "some_id",
"name": "Some App",
"object": "application"
},
"application_fee": null,
"amount": 5
}
],
"has_more": false,
"object": "list",
"url": "/v1/charges"
}
{code}
I ran some further tests on the query and found out that the query only fails
at object "application_fee", which is null in both arrays of object "data".
Which might explain why I never ran into this error in the other datasets (no
object arrays there are null).
was:
I tried this query on some of our JSON files that are stored in a S3 Bucket, in
which I tried to convert JSON objects (application, application_fee) into
varchar:
{quote}SELECT
CONCAT(
'"', CONVERT_TO(_stg.data.application_fee, 'JSON'), '"'
, ',', '"', CONVERT_TO(_stg.data.application_fee, 'JSON'), '"'
) as JSONs
FROM (
SELECT
flatten(js.data) AS data
FROM
s3_bucket.`` AS js
) _stg
{quote}
On some of the datasets the query failed and I got this error message
{quote}org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR:
UnsupportedOperationException: Unable to get holder type for minor type [LATE]
and mode [OPTIONAL] Fragment 0:0 [Error Id: 5e74e125-de22-46fa-8d31-233d0fc40140
{quote}
The dataset, on which the query failed looks like following:
bq. "data":
bq. [
bq. {
bq. "application": null,
bq. "application_fee": null,
bq. "amount": 1
bq. },
bq. {
bq. "application":
bq. {
bq. "id": "some_id",
bq. "name": "Some App",
bq. "object": "application"
bq. },
bq. "application_fee": null,
bq. "amount": 5
bq. }
bq. ],
bq. "has_more": false,
bq. "object": "list",
bq. "url": "/v1/charges"
bq. }
I ran some further tests on the query and found out that the query only fails
at object "application_fee", which is null in both arrays of object "data".
Which might explain why I never ran into this error in the other datasets (no
object arrays there are null).
> UnsupportedOperationException: Unable to get holder type for minor type
> [LATE] and mode [OPTIONAL]
> --
>
> Key: DRILL-6390
> URL: https://issues.apache.org/jira/browse/DRILL-6390
> Project: Apache Drill
> Issue Type: Bug
> Components: Execution - Data Types, Storage - JSON
>Affects Versions: 1.11.0
>Reporter: Trung Ta
>Priority: Major
>
> I tried this query on some of our JSON files that are stored in a S3 Bucket,
> in which I tried to convert JSON objects (application, application_fee) into
> varchar:
> {quote}SELECT
> CONCAT(
> '"', CONVERT_TO(_stg.data.application_fee, 'JSON'), '"'
> , ',', '"', CONVERT_TO(_stg.data.application_fee, 'JSON'), '"'
> ) as JSONs
> FROM (
> SELECT
> flatten(js.data) AS data
> FROM
> s3_bucket.`` AS js
> ) _stg
> {quote}
> On some of the datasets the query failed and I got this error message
> {quote}org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR:
> UnsupportedOperationException: Unable to get holder type for minor type
> [LATE] and mode [OPTIONAL] Fragment 0:0 [Error Id:
> 5e74e125-de22-46fa-8d31-233d0fc40140
> {quote}
> The dataset, on which the query failed looks like following:
> {code:java}
> {
> "data":
> [
> {
> "application": null,
> "application_fee": null,
> "amount": 1
> },
> {
>
[jira] [Updated] (DRILL-6390) UnsupportedOperationException: Unable to get holder type for minor type [LATE] and mode [OPTIONAL]
[
https://issues.apache.org/jira/browse/DRILL-6390?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Trung Ta updated DRILL-6390:
Description:
I tried this query on some of our JSON files that are stored in a S3 Bucket, in
which I tried to convert JSON objects (application, application_fee) into
varchar:
{quote}SELECT
CONCAT(
'"', CONVERT_TO(_stg.data.application_fee, 'JSON'), '"'
, ',', '"', CONVERT_TO(_stg.data.application_fee, 'JSON'), '"'
) as JSONs
FROM (
SELECT
flatten(js.data) AS data
FROM
s3_bucket.`` AS js
) _stg
{quote}
On some of the datasets the query failed and I got this error message
{quote}org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR:
UnsupportedOperationException: Unable to get holder type for minor type [LATE]
and mode [OPTIONAL] Fragment 0:0 [Error Id: 5e74e125-de22-46fa-8d31-233d0fc40140
{quote}
The dataset, on which the query failed looks like following:
{
"data":
[
{
"application": null,
"application_fee": null,
"amount": 1
},
{
"application":
{
"id": "some_id",
"name": "Some App",
"object": "application"
},
"application_fee": null,
"amount": 5
}
],
"has_more": false,
"object": "list",
"url": "/v1/charges"
}
I ran some further tests on the query and found out that the query only fails
at object "application_fee", which is null in both arrays of object "data".
Which might explain why I never ran into this error in the other datasets (no
object arrays there are null).
was:
I tried this query on some of our JSON files that are stored in a S3 Bucket, in
which I tried to convert JSON objects (application, application_fee) into
varchar:
{quote}SELECT
CONCAT(
'"', CONVERT_TO(_stg.data.application_fee, 'JSON'), '"'
, ',', '"', CONVERT_TO(_stg.data.application_fee, 'JSON'), '"'
) as JSONs
FROM (
SELECT
flatten(js.data) AS data
FROM
s3_bucket.`` AS js
) _stg
{quote}
On some of the datasets the query failed and I got this error message
{quote}org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR:
UnsupportedOperationException: Unable to get holder type for minor type [LATE]
and mode [OPTIONAL] Fragment 0:0 [Error Id: 5e74e125-de22-46fa-8d31-233d0fc40140
{quote}
The dataset, on which the query failed looks like following:
{
"data":
[
{
"application": null,
"application_fee": null,
"amount": 1
},
{
"application":
{
"id": "some_id",
"name": "Some App",
"object": "application"
},
"application_fee": null,
"amount": 5
}
],
"has_more": false,
"object": "list",
"url": "/v1/charges"
}
I ran some further tests on the query and found out that the query only fails
at object "application_fee", which is null in both arrays of object "data".
Which might explain why I never ran into this error in the other datasets (no
object arrays there are null).
> UnsupportedOperationException: Unable to get holder type for minor type
> [LATE] and mode [OPTIONAL]
> --
>
> Key: DRILL-6390
> URL: https://issues.apache.org/jira/browse/DRILL-6390
> Project: Apache Drill
> Issue Type: Bug
> Components: Execution - Data Types, Storage - JSON
>Affects Versions: 1.11.0
>Reporter: Trung Ta
>Priority: Major
>
>
> I tried this query on some of our JSON files that are stored in a S3 Bucket,
> in which I tried to convert JSON objects (application, application_fee) into
> varchar:
> {quote}SELECT
> CONCAT(
> '"', CONVERT_TO(_stg.data.application_fee, 'JSON'), '"'
> , ',', '"', CONVERT_TO(_stg.data.application_fee, 'JSON'), '"'
> ) as JSONs
> FROM (
> SELECT
> flatten(js.data) AS data
> FROM
> s3_bucket.`` AS js
> ) _stg
> {quote}
> On some of the datasets the query failed and I got this error message
> {quote}org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR:
> UnsupportedOperationException: Unable to get holder type for minor type
> [LATE] and mode [OPTIONAL] Fragment 0:0 [Error Id:
> 5e74e125-de22-46fa-8d31-233d0fc40140
> {quote}
> The dataset, on which the query failed looks like following:
> {
> "data":
> [
> {
> "application": null,
> "application_fee": null,
> "amount": 1
> },
> {
> "application":
> {
> "id": "some_id",
> "name": "Some App",
>
[jira] [Updated] (DRILL-6390) UnsupportedOperationException: Unable to get holder type for minor type [LATE] and mode [OPTIONAL]
[
https://issues.apache.org/jira/browse/DRILL-6390?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Trung Ta updated DRILL-6390:
Component/s: Storage - JSON
Execution - Data Types
> UnsupportedOperationException: Unable to get holder type for minor type
> [LATE] and mode [OPTIONAL]
> --
>
> Key: DRILL-6390
> URL: https://issues.apache.org/jira/browse/DRILL-6390
> Project: Apache Drill
> Issue Type: Bug
> Components: Execution - Data Types, Storage - JSON
>Affects Versions: 1.11.0
>Reporter: Trung Ta
>Priority: Major
>
>
> I tried this query on some of our JSON files that are stored in a S3 Bucket,
> in which I tried to convert JSON objects (application, application_fee) into
> varchar:
> {quote}SELECT
> CONCAT(
> '"', CONVERT_TO(_stg.data.application_fee, 'JSON'), '"'
> , ',', '"', CONVERT_TO(_stg.data.application_fee, 'JSON'), '"'
> ) as JSONs
> FROM (
> SELECT
> flatten(js.data) AS data
> FROM
> s3_bucket.`` AS js
> ) _stg
> {quote}
> On some of the datasets the query failed and I got this error message
> {quote}org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR:
> UnsupportedOperationException: Unable to get holder type for minor type
> [LATE] and mode [OPTIONAL] Fragment 0:0 [Error Id:
> 5e74e125-de22-46fa-8d31-233d0fc40140
> {quote}
> The dataset, on which the query failed looks like following:
> {
> "data":
> [
> {
> "application": null,
> "application_fee": null,
> "amount": 1
> },
> {
> "application":
> {
> "id": "some_id",
> "name": "Some App",
> "object": "application"
> },
> "application_fee": null,
> "amount": 5
> }
> ],
> "has_more": false,
> "object": "list",
> "url": "/v1/charges"
> }
> I ran some further tests on the query and found out that the query only fails
> at object "application_fee", which is null in both arrays of object "data".
> Which might explain why I never ran into this error in the other datasets (no
> object arrays there are null).
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
[jira] [Updated] (DRILL-6390) UnsupportedOperationException: Unable to get holder type for minor type [LATE] and mode [OPTIONAL]
[
https://issues.apache.org/jira/browse/DRILL-6390?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Trung Ta updated DRILL-6390:
Description:
I tried this query on some of our JSON files that are stored in a S3 Bucket, in
which I tried to convert JSON objects (application, application_fee) into
varchar:
{quote}SELECT
CONCAT(
'"', CONVERT_TO(_stg.data.application_fee, 'JSON'), '"'
, ',', '"', CONVERT_TO(_stg.data.application_fee, 'JSON'), '"'
) as JSONs
FROM (
SELECT
flatten(js.data) AS data
FROM
s3_bucket.`` AS js
) _stg
{quote}
On some of the datasets the query failed and I got this error message
{quote}org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR:
UnsupportedOperationException: Unable to get holder type for minor type [LATE]
and mode [OPTIONAL] Fragment 0:0 [Error Id: 5e74e125-de22-46fa-8d31-233d0fc40140
{quote}
The dataset, on which the query failed looks like following:
{
"data":
[
{
"application": null,
"application_fee": null,
"amount": 1
},
{
"application":
{
"id": "some_id",
"name": "Some App",
"object": "application"
},
"application_fee": null,
"amount": 5
}
],
"has_more": false,
"object": "list",
"url": "/v1/charges"
}
I ran some further tests on the query and found out that the query only fails
at object "application_fee", which is null in both arrays of object "data".
Which might explain why I never ran into this error in the other datasets (no
object arrays there are null).
was:
I tried this query on some of our JSON files that are stored in a S3 Bucket, in
which I tried to convert JSON objects (application, application_fee) into
varchar:
{quote}SELECT
CONCAT(
'"', CONVERT_TO(_stg.data.application_fee, 'JSON'), '"'
, ',', '"', CONVERT_TO(_stg.data.application_fee, 'JSON'), '"'
) as JSONs
FROM (
SELECT
flatten(js.data) AS data
FROM
s3_bucket.`` AS js
) _stg
{quote}
On some of the datasets the query failed and I got this error message
{quote}org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR:
UnsupportedOperationException: Unable to get holder type for minor type [LATE]
and mode [OPTIONAL] Fragment 0:0 [Error Id: 5e74e125-de22-46fa-8d31-233d0fc40140
{quote}
The dataset, on which the query failed looks like following:
{
"data":
[
{
"application": null,
"application_fee": null,
"amount": 1
},
{
"application":
{
"id": "some_id",
"name": "Some App",
"object": "application"
},
"application_fee": null,
"amount": 5
}
],
"has_more": false,
"object": "list",
"url": "/v1/charges"
}
I ran some further tests on the query and found out that the query only fails
at object "application_fee", which is null in both arrays of object "data".
Which might explain why I never ran into this error in the other datasets (no
object arrays there are null).
> UnsupportedOperationException: Unable to get holder type for minor type
> [LATE] and mode [OPTIONAL]
> --
>
> Key: DRILL-6390
> URL: https://issues.apache.org/jira/browse/DRILL-6390
> Project: Apache Drill
> Issue Type: Bug
>Affects Versions: 1.11.0
>Reporter: Trung Ta
>Priority: Major
>
>
> I tried this query on some of our JSON files that are stored in a S3 Bucket,
> in which I tried to convert JSON objects (application, application_fee) into
> varchar:
> {quote}SELECT
> CONCAT(
> '"', CONVERT_TO(_stg.data.application_fee, 'JSON'), '"'
> , ',', '"', CONVERT_TO(_stg.data.application_fee, 'JSON'), '"'
> ) as JSONs
> FROM (
> SELECT
> flatten(js.data) AS data
> FROM
> s3_bucket.`` AS js
> ) _stg
> {quote}
> On some of the datasets the query failed and I got this error message
> {quote}org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR:
> UnsupportedOperationException: Unable to get holder type for minor type
> [LATE] and mode [OPTIONAL] Fragment 0:0 [Error Id:
> 5e74e125-de22-46fa-8d31-233d0fc40140
> {quote}
> The dataset, on which the query failed looks like following:
> {
> "data":
> [
> {
> "application": null,
>
[jira] [Updated] (DRILL-6390) UnsupportedOperationException: Unable to get holder type for minor type [LATE] and mode [OPTIONAL]
[
https://issues.apache.org/jira/browse/DRILL-6390?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Trung Ta updated DRILL-6390:
Description:
I tried this query on some of our JSON files that are stored in a S3 Bucket, in
which I tried to convert JSON objects (application, application_fee) into
varchar:
{quote}SELECT
CONCAT(
'"', CONVERT_TO(_stg.data.application_fee, 'JSON'), '"'
, ',', '"', CONVERT_TO(_stg.data.application_fee, 'JSON'), '"'
) as JSONs
FROM (
SELECT
flatten(js.data) AS data
FROM
s3_bucket.`` AS js
) _stg
{quote}
On some of the datasets the query failed and I got this error message
{quote}org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR:
UnsupportedOperationException: Unable to get holder type for minor type [LATE]
and mode [OPTIONAL] Fragment 0:0 [Error Id: 5e74e125-de22-46fa-8d31-233d0fc40140
{quote}
The dataset, on which the query failed looks like following:
{
"data":
[
{
"application": null,
"application_fee": null,
"amount": 1
},
{
"application":
{
"id": "some_id",
"name": "Some App",
"object": "application"
},
"application_fee": null,
"amount": 5
}
],
"has_more": false,
"object": "list",
"url": "/v1/charges"
}
I ran some further tests on the query and found out that the query only fails
at object "application_fee", which is null in both arrays of object "data".
Which might explain why I never ran into this error in the other datasets (no
object arrays there are null).
was:
I tried this query on some of our JSON files that are stored in a S3 Bucket, in
which I tried to convert JSON objects (application, application_fee) into
varchar:
{quote}SELECT
CONCAT(
'"', CONVERT_TO(_stg.data.application_fee, 'JSON'), '"'
, ',', '"', CONVERT_TO(_stg.data.application_fee, 'JSON'), '"'
) as JSONs
FROM (
SELECT
flatten(js.data) AS data
FROM
s3_bucket.`` AS js
) _stg
{quote}
On some of the datasets the query failed and I got this error message
{quote}org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR:
UnsupportedOperationException: Unable to get holder type for minor type [LATE]
and mode [OPTIONAL] Fragment 0:0 [Error Id: 5e74e125-de22-46fa-8d31-233d0fc40140
{quote}
The dataset, on which the query failed looks like following:
{quote}{
{
"data":
[
{
"application": null,
"application_fee": null,
"amount": 1
},
{
"application":
{
"id": "some_id",
"name": "Some App",
"object": "application"
},
"application_fee": null,
"amount": 5
}
],
"has_more": false,
"object": "list",
"url": "/v1/charges"
}
{quote}
I ran some further tests on the query and found out that the query only fails
at object "application_fee", which is null in both arrays of object "data".
Which might explain why I never ran into this error in the other datasets (no
object arrays there are null).
> UnsupportedOperationException: Unable to get holder type for minor type
> [LATE] and mode [OPTIONAL]
> --
>
> Key: DRILL-6390
> URL: https://issues.apache.org/jira/browse/DRILL-6390
> Project: Apache Drill
> Issue Type: Bug
>Affects Versions: 1.11.0
>Reporter: Trung Ta
>Priority: Major
>
>
> I tried this query on some of our JSON files that are stored in a S3 Bucket,
> in which I tried to convert JSON objects (application, application_fee) into
> varchar:
> {quote}SELECT
> CONCAT(
> '"', CONVERT_TO(_stg.data.application_fee, 'JSON'), '"'
> , ',', '"', CONVERT_TO(_stg.data.application_fee, 'JSON'), '"'
> ) as JSONs
> FROM (
> SELECT
> flatten(js.data) AS data
> FROM
> s3_bucket.`` AS js
> ) _stg
> {quote}
> On some of the datasets the query failed and I got this error message
> {quote}org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR:
> UnsupportedOperationException: Unable to get holder type for minor type
> [LATE] and mode [OPTIONAL] Fragment 0:0 [Error Id:
> 5e74e125-de22-46fa-8d31-233d0fc40140
> {quote}
> The dataset, on which the query failed looks like following:
> {
> "data":
> [
> {
> "application": null,
>
[jira] [Updated] (DRILL-6390) UnsupportedOperationException: Unable to get holder type for minor type [LATE] and mode [OPTIONAL]
[
https://issues.apache.org/jira/browse/DRILL-6390?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Trung Ta updated DRILL-6390:
Description:
I tried this query on some of our JSON files that are stored in a S3 Bucket, in
which I tried to convert JSON objects (application, application_fee) into
varchar:
{quote}SELECT
CONCAT(
'"', CONVERT_TO(_stg.data.application_fee, 'JSON'), '"'
, ',', '"', CONVERT_TO(_stg.data.application_fee, 'JSON'), '"'
) as JSONs
FROM (
SELECT
flatten(js.data) AS data
FROM
s3_bucket.`` AS js
) _stg
{quote}
On some of the datasets the query failed and I got this error message
{quote}org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR:
UnsupportedOperationException: Unable to get holder type for minor type [LATE]
and mode [OPTIONAL] Fragment 0:0 [Error Id: 5e74e125-de22-46fa-8d31-233d0fc40140
{quote}
The dataset, on which the query failed looks like following:
{quote}{
{
"data":
[
{
"application": null,
"application_fee": null,
"amount": 1
},
{
"application":
{
"id": "some_id",
"name": "Some App",
"object": "application"
},
"application_fee": null,
"amount": 5
}
],
"has_more": false,
"object": "list",
"url": "/v1/charges"
}
{quote}
I ran some further tests on the query and found out that the query only fails
at object "application_fee", which is null in both arrays of object "data".
Which might explain why I never ran into this error in the other datasets (no
object arrays there are null).
was:
I tried this query on some of our JSON files that are stored in a S3 Bucket, in
which I tried to convert JSON objects (application, application_fee) into
varchar:
{quote}SELECT
CONCAT(
'"', CONVERT_TO(_stg.data.application_fee, 'JSON'), '"'
, ',', '"', CONVERT_TO(_stg.data.application_fee, 'JSON'), '"'
) as JSONs
FROM (
SELECT
flatten(js.data) AS data
FROM
s3_bucket.`` AS js
) _stg
{quote}
On some of the datasets the query failed and I got this error message
{quote}org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR:
UnsupportedOperationException: Unable to get holder type for minor type [LATE]
and mode [OPTIONAL] Fragment 0:0 [Error Id: 5e74e125-de22-46fa-8d31-233d0fc40140
{quote}
The dataset, on which the query failed looks like following:
{quote}{
"data":
[
{
"application": null,
"application_fee": null,
"amount": 1
},
{
"application":
{
"id": "some_id",
"name": "Some App",
"object": "application"
},
"application_fee": null,
"amount": 5
}
],
"has_more": false,
"object": "list",
"url": "/v1/charges"
}
{quote}
I ran some further tests on the query and found out that the query only fails
at object "application_fee", which is null in both arrays of object "data".
Which might explain why I never ran into this error in the other datasets (no
object arrays there are null).
> UnsupportedOperationException: Unable to get holder type for minor type
> [LATE] and mode [OPTIONAL]
> --
>
> Key: DRILL-6390
> URL: https://issues.apache.org/jira/browse/DRILL-6390
> Project: Apache Drill
> Issue Type: Bug
>Affects Versions: 1.11.0
>Reporter: Trung Ta
>Priority: Major
>
>
> I tried this query on some of our JSON files that are stored in a S3 Bucket,
> in which I tried to convert JSON objects (application, application_fee) into
> varchar:
> {quote}SELECT
> CONCAT(
> '"', CONVERT_TO(_stg.data.application_fee, 'JSON'), '"'
> , ',', '"', CONVERT_TO(_stg.data.application_fee, 'JSON'), '"'
> ) as JSONs
> FROM (
> SELECT
> flatten(js.data) AS data
> FROM
> s3_bucket.`` AS js
> ) _stg
> {quote}
> On some of the datasets the query failed and I got this error message
> {quote}org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR:
> UnsupportedOperationException: Unable to get holder type for minor type
> [LATE] and mode [OPTIONAL] Fragment 0:0 [Error Id:
> 5e74e125-de22-46fa-8d31-233d0fc40140
> {quote}
> The dataset, on which the query failed looks like following:
> {quote}{
> {
> "data":
> [
> {
> "application": null,
> "application_fee": null,
> "amount": 1
> },
> {
> "application":
> {
> "id": "some_id",
> "name": "Some App",
>
[jira] [Updated] (DRILL-6390) UnsupportedOperationException: Unable to get holder type for minor type [LATE] and mode [OPTIONAL]
[
https://issues.apache.org/jira/browse/DRILL-6390?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Trung Ta updated DRILL-6390:
Description:
I tried this query on some of our JSON files that are stored in a S3 Bucket, in
which I tried to convert JSON objects (application, application_fee) into
varchar:
{quote}SELECT
CONCAT(
'"', CONVERT_TO(_stg.data.application_fee, 'JSON'), '"'
, ',', '"', CONVERT_TO(_stg.data.application_fee, 'JSON'), '"'
) as JSONs
FROM (
SELECT
flatten(js.data) AS data
FROM
s3_bucket.`` AS js
) _stg
{quote}
On some of the datasets the query failed and I got this error message
{quote}org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR:
UnsupportedOperationException: Unable to get holder type for minor type [LATE]
and mode [OPTIONAL] Fragment 0:0 [Error Id: 5e74e125-de22-46fa-8d31-233d0fc40140
{quote}
The dataset, on which the query failed looks like following:
{quote}{
"data":
[
{
"application": null,
"application_fee": null,
"amount": 1
},
{
"application":
{
"id": "some_id",
"name": "Some App",
"object": "application"
},
"application_fee": null,
"amount": 5
}
],
"has_more": false,
"object": "list",
"url": "/v1/charges"
}
{quote}
I ran some further tests on the query and found out that the query only fails
at object "application_fee", which is null in both arrays of object "data".
Which might explain why I never ran into this error in the other datasets (no
object arrays there are null).
was:
I tried this query on some of our JSON files that are stored in a S3 Bucket, in
which I tried to convert JSON objects (application, application_fee) into
varchar:
{quote}SELECT
CONCAT(
'"', CONVERT_TO(_stg.data.application_fee, 'JSON'), '"'
, ',', '"', CONVERT_TO(_stg.data.application_fee, 'JSON'), '"'
) as JSONs
FROM (
SELECT
flatten(js.data) AS data
FROM
s3_bucket.`` AS js
) _stg
{quote}
On some of the datasets the query failed and I got this error message
{quote}org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR:
UnsupportedOperationException: Unable to get holder type for minor type [LATE]
and mode [OPTIONAL] Fragment 0:0 [Error Id: 5e74e125-de22-46fa-8d31-233d0fc40140
{quote}
The dataset, on which the query failed looks like following:
{quote}{
"data":
[
{
"application": null,
"application_fee": null,
"amount": 1
},
{
"application":
{
"id": "some_id",
"name": "Some App",
"object": "application"
},
"application_fee": null,
"amount": 5
}
],
"has_more": false,
"object": "list",
"url": "/v1/charges"
}
{quote}
I ran some further tests on the query and found out that the query only fails
at object "application_fee", which is null in both arrays of object "data".
Which might explain why I never ran into this error in the other datasets (no
object arrays there are null).
> UnsupportedOperationException: Unable to get holder type for minor type
> [LATE] and mode [OPTIONAL]
> --
>
> Key: DRILL-6390
> URL: https://issues.apache.org/jira/browse/DRILL-6390
> Project: Apache Drill
> Issue Type: Bug
>Affects Versions: 1.11.0
>Reporter: Trung Ta
>Priority: Major
>
>
> I tried this query on some of our JSON files that are stored in a S3 Bucket,
> in which I tried to convert JSON objects (application, application_fee) into
> varchar:
> {quote}SELECT
> CONCAT(
> '"', CONVERT_TO(_stg.data.application_fee, 'JSON'), '"'
> , ',', '"', CONVERT_TO(_stg.data.application_fee, 'JSON'), '"'
> ) as JSONs
> FROM (
> SELECT
> flatten(js.data) AS data
> FROM
> s3_bucket.`` AS js
> ) _stg
> {quote}
> On some of the datasets the query failed and I got this error message
> {quote}org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR:
> UnsupportedOperationException: Unable to get holder type for minor type
> [LATE] and mode [OPTIONAL] Fragment 0:0 [Error Id:
> 5e74e125-de22-46fa-8d31-233d0fc40140
> {quote}
> The dataset, on which the query failed looks like following:
> {quote}{
> "data":
> [
> {
> "application": null,
> "application_fee": null,
> "amount": 1
> },
> {
> "application":
> {
> "id": "some_id",
> "name": "Some App",
> "object": "application"
> },
> "application_fee": null,
> "amount": 5
> }
> ],
> "has_more": false,
> "object": "list",
> "url": "/v1/charges"
> }
> {quote}
> I
[jira] [Updated] (DRILL-6390) UnsupportedOperationException: Unable to get holder type for minor type [LATE] and mode [OPTIONAL]
[
https://issues.apache.org/jira/browse/DRILL-6390?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Trung Ta updated DRILL-6390:
Affects Version/s: 1.11.0
> UnsupportedOperationException: Unable to get holder type for minor type
> [LATE] and mode [OPTIONAL]
> --
>
> Key: DRILL-6390
> URL: https://issues.apache.org/jira/browse/DRILL-6390
> Project: Apache Drill
> Issue Type: Bug
>Affects Versions: 1.11.0
>Reporter: Trung Ta
>Priority: Major
>
>
> I tried this query on some of our JSON files that are stored in a S3 Bucket,
> in which I tried to convert JSON objects (application, application_fee) into
> varchar:
> {quote}SELECT
> CONCAT(
> '"', CONVERT_TO(_stg.data.application_fee, 'JSON'), '"'
> , ',', '"', CONVERT_TO(_stg.data.application_fee, 'JSON'), '"'
> ) as JSONs
> FROM (
> SELECT
> flatten(js.data) AS data
> FROM
> s3_bucket.`` AS js
> ) _stg
> {quote}
> On some of the datasets the query failed and I got this error message
> {quote}org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR:
> UnsupportedOperationException: Unable to get holder type for minor type
> [LATE] and mode [OPTIONAL] Fragment 0:0 [Error Id:
> 5e74e125-de22-46fa-8d31-233d0fc40140
> {quote}
> The dataset, on which the query failed looks like following:
> {quote}{
> "data":
> [
> {
> "application": null,
> "application_fee": null,
> "amount": 1
> },
> {
> "application":
> {
> "id": "some_id",
> "name": "Some App",
> "object": "application"
> },
> "application_fee": null,
> "amount": 5
> }
> ],
> "has_more": false,
> "object": "list",
> "url": "/v1/charges"
> }
> {quote}
> I ran some further tests on the query and found out that the query only fails
> at object "application_fee", which is null in both arrays of object "data".
> Which might explain why I never ran into this error in the other datasets (no
> object arrays there are null).
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
