[jira] [Updated] (DRILL-1891) Error message does not get propagated correctly when reading from JSON file
[
https://issues.apache.org/jira/browse/DRILL-1891?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Deneche A. Hakim updated DRILL-1891:
Fix Version/s: (was: 0.9.0)
1.0.0
Error message does not get propagated correctly when reading from JSON file
---
Key: DRILL-1891
URL: https://issues.apache.org/jira/browse/DRILL-1891
Project: Apache Drill
Issue Type: Bug
Components: Storage - JSON
Affects Versions: 0.7.0
Reporter: Victoria Markman
Assignee: Deneche A. Hakim
Fix For: 1.0.0
I made a mistake in t.json file (extra colon in the last row):
{code}
{ a1: 0 , b1: a}
{ a1: 1 , b1: b}
{ a1: 2 , b1: c}
{ a1:: 3 , b1: c}
{code}
Error message below pretty much tells me everything that went wrong.
{code}
0: jdbc:drill:schema=dfs select a1 from `t.json` where a1 is not null;
Query failed: Query stopped., Unexpected character (':' (code 58)): expected
a valid value (number, String, array, object, 'true', 'false' or 'null')
at [Source: org.apache.drill.exec.vector.complex.fn.JsonReader@53c10ede;
line: 3, column: 9] [ 64182782-ebba-4c6a-a963-005b8cb48339 on
atsqa4-133.qa.lab:31010 ]
{code}
However, if a result of query above is an input to any other operator, I get
this error message:
{code}
0: jdbc:drill:schema=dfs select a1 from `t.json` where a1 is not null group
by a1;
Query failed: Query failed: Failure while running fragment., You tried to do
a batch data read operation when you were in a state of STOP. You can only
do this type of operation when you are in a state of OK or OK_NEW_SCHEMA. [
955aac65-5e43-4430-baf6-ed6bb8a020d9 on atsqa4-133.qa.lab:31010 ]
[ 955aac65-5e43-4430-baf6-ed6bb8a020d9 on atsqa4-133.qa.lab:31010 ]
Error: exception while executing query: Failure while executing query.
(state=,code=0)
{code}
Very painful for the user if query is really complex.
The same behavior if file does not exist.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Updated] (DRILL-1891) Error message does not get propagated correctly when reading from JSON file
[
https://issues.apache.org/jira/browse/DRILL-1891?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sudheesh Katkam updated DRILL-1891:
---
Assignee: Deneche A. Hakim (was: Sudheesh Katkam)
Error message does not get propagated correctly when reading from JSON file
---
Key: DRILL-1891
URL: https://issues.apache.org/jira/browse/DRILL-1891
Project: Apache Drill
Issue Type: Bug
Components: Storage - JSON
Affects Versions: 0.7.0
Reporter: Victoria Markman
Assignee: Deneche A. Hakim
Fix For: 0.9.0
I made a mistake in t.json file (extra colon in the last row):
{code}
{ a1: 0 , b1: a}
{ a1: 1 , b1: b}
{ a1: 2 , b1: c}
{ a1:: 3 , b1: c}
{code}
Error message below pretty much tells me everything that went wrong.
{code}
0: jdbc:drill:schema=dfs select a1 from `t.json` where a1 is not null;
Query failed: Query stopped., Unexpected character (':' (code 58)): expected
a valid value (number, String, array, object, 'true', 'false' or 'null')
at [Source: org.apache.drill.exec.vector.complex.fn.JsonReader@53c10ede;
line: 3, column: 9] [ 64182782-ebba-4c6a-a963-005b8cb48339 on
atsqa4-133.qa.lab:31010 ]
{code}
However, if a result of query above is an input to any other operator, I get
this error message:
{code}
0: jdbc:drill:schema=dfs select a1 from `t.json` where a1 is not null group
by a1;
Query failed: Query failed: Failure while running fragment., You tried to do
a batch data read operation when you were in a state of STOP. You can only
do this type of operation when you are in a state of OK or OK_NEW_SCHEMA. [
955aac65-5e43-4430-baf6-ed6bb8a020d9 on atsqa4-133.qa.lab:31010 ]
[ 955aac65-5e43-4430-baf6-ed6bb8a020d9 on atsqa4-133.qa.lab:31010 ]
Error: exception while executing query: Failure while executing query.
(state=,code=0)
{code}
Very painful for the user if query is really complex.
The same behavior if file does not exist.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Updated] (DRILL-1891) Error message does not get propagated correctly when reading from JSON file
[
https://issues.apache.org/jira/browse/DRILL-1891?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jacques Nadeau updated DRILL-1891:
--
Fix Version/s: 0.9.0
Assignee: Jason Altekruse
Error message does not get propagated correctly when reading from JSON file
---
Key: DRILL-1891
URL: https://issues.apache.org/jira/browse/DRILL-1891
Project: Apache Drill
Issue Type: Bug
Components: Storage - JSON
Affects Versions: 0.7.0
Reporter: Victoria Markman
Assignee: Jason Altekruse
Fix For: 0.9.0
I made a mistake in t.json file (extra colon in the last row):
{code}
{ a1: 0 , b1: a}
{ a1: 1 , b1: b}
{ a1: 2 , b1: c}
{ a1:: 3 , b1: c}
{code}
Error message below pretty much tells me everything that went wrong.
{code}
0: jdbc:drill:schema=dfs select a1 from `t.json` where a1 is not null;
Query failed: Query stopped., Unexpected character (':' (code 58)): expected
a valid value (number, String, array, object, 'true', 'false' or 'null')
at [Source: org.apache.drill.exec.vector.complex.fn.JsonReader@53c10ede;
line: 3, column: 9] [ 64182782-ebba-4c6a-a963-005b8cb48339 on
atsqa4-133.qa.lab:31010 ]
{code}
However, if a result of query above is an input to any other operator, I get
this error message:
{code}
0: jdbc:drill:schema=dfs select a1 from `t.json` where a1 is not null group
by a1;
Query failed: Query failed: Failure while running fragment., You tried to do
a batch data read operation when you were in a state of STOP. You can only
do this type of operation when you are in a state of OK or OK_NEW_SCHEMA. [
955aac65-5e43-4430-baf6-ed6bb8a020d9 on atsqa4-133.qa.lab:31010 ]
[ 955aac65-5e43-4430-baf6-ed6bb8a020d9 on atsqa4-133.qa.lab:31010 ]
Error: exception while executing query: Failure while executing query.
(state=,code=0)
{code}
Very painful for the user if query is really complex.
The same behavior if file does not exist.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Updated] (DRILL-1891) Error message does not get propagated correctly when reading from JSON file
[
https://issues.apache.org/jira/browse/DRILL-1891?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Victoria Markman updated DRILL-1891:
Description:
I made a mistake in t.json file (extra colon in the last row):
{code}
{ a1: 0 , b1: a}
{ a1: 1 , b1: b}
{ a1: 2 , b1: c}
{ a1:: 3 , b1: c}
{code}
Error message below pretty much tells me everything that went wrong.
{code}
0: jdbc:drill:schema=dfs select a1 from `t.json` where a1 is not null;
Query failed: Query stopped., Unexpected character (':' (code 58)): expected a
valid value (number, String, array, object, 'true', 'false' or 'null')
at [Source: org.apache.drill.exec.vector.complex.fn.JsonReader@53c10ede; line:
3, column: 9] [ 64182782-ebba-4c6a-a963-005b8cb48339 on atsqa4-133.qa.lab:31010
]
{code}
However, if a result of query above is an input to any other operator, I get
this error message:
{code}
0: jdbc:drill:schema=dfs select a1 from `t.json` where a1 is not null group by
a1;
Query failed: Query failed: Failure while running fragment., You tried to do a
batch data read operation when you were in a state of STOP. You can only do
this type of operation when you are in a state of OK or OK_NEW_SCHEMA. [
955aac65-5e43-4430-baf6-ed6bb8a020d9 on atsqa4-133.qa.lab:31010 ]
[ 955aac65-5e43-4430-baf6-ed6bb8a020d9 on atsqa4-133.qa.lab:31010 ]
Error: exception while executing query: Failure while executing query.
(state=,code=0)
{code}
Very painful for the user if query is really complex.
The same behavior if file does not exist.
was:
I made a mistake in t.json file (extra colon in the last row):
{ a1: 0 , b1: a}
{ a1: 1 , b1: b}
{ a1: 2 , b1: c}
{ a1:: 3 , b1: c}
Error message below pretty much tells me everything that went wrong.
0: jdbc:drill:schema=dfs select a1 from `t.json` where a1 is not null;
Query failed: Query stopped., Unexpected character (':' (code 58)): expected a
valid value (number, String, array, object, 'true', 'false' or 'null')
at [Source: org.apache.drill.exec.vector.complex.fn.JsonReader@53c10ede; line:
3, column: 9] [ 64182782-ebba-4c6a-a963-005b8cb48339 on atsqa4-133.qa.lab:31010
]
However, if a result of query above is an input to any other operator, I get
this error message:
0: jdbc:drill:schema=dfs select a1 from `t.json` where a1 is not null group by
a1;
Query failed: Query failed: Failure while running fragment., You tried to do a
batch data read operation when you were in a state of STOP. You can only do
this type of operation when you are in a state of OK or OK_NEW_SCHEMA. [
955aac65-5e43-4430-baf6-ed6bb8a020d9 on atsqa4-133.qa.lab:31010 ]
[ 955aac65-5e43-4430-baf6-ed6bb8a020d9 on atsqa4-133.qa.lab:31010 ]
Error: exception while executing query: Failure while executing query.
(state=,code=0)
Very painful for the user if query is really complex.
The same behavior if file does not exist.
Error message does not get propagated correctly when reading from JSON file
---
Key: DRILL-1891
URL: https://issues.apache.org/jira/browse/DRILL-1891
Project: Apache Drill
Issue Type: Bug
Components: Storage - JSON
Affects Versions: 0.7.0
Reporter: Victoria Markman
I made a mistake in t.json file (extra colon in the last row):
{code}
{ a1: 0 , b1: a}
{ a1: 1 , b1: b}
{ a1: 2 , b1: c}
{ a1:: 3 , b1: c}
{code}
Error message below pretty much tells me everything that went wrong.
{code}
0: jdbc:drill:schema=dfs select a1 from `t.json` where a1 is not null;
Query failed: Query stopped., Unexpected character (':' (code 58)): expected
a valid value (number, String, array, object, 'true', 'false' or 'null')
at [Source: org.apache.drill.exec.vector.complex.fn.JsonReader@53c10ede;
line: 3, column: 9] [ 64182782-ebba-4c6a-a963-005b8cb48339 on
atsqa4-133.qa.lab:31010 ]
{code}
However, if a result of query above is an input to any other operator, I get
this error message:
{code}
0: jdbc:drill:schema=dfs select a1 from `t.json` where a1 is not null group
by a1;
Query failed: Query failed: Failure while running fragment., You tried to do
a batch data read operation when you were in a state of STOP. You can only
do this type of operation when you are in a state of OK or OK_NEW_SCHEMA. [
955aac65-5e43-4430-baf6-ed6bb8a020d9 on atsqa4-133.qa.lab:31010 ]
[ 955aac65-5e43-4430-baf6-ed6bb8a020d9 on atsqa4-133.qa.lab:31010 ]
Error: exception while executing query: Failure while executing query.
(state=,code=0)
{code}
Very painful for the user if query is really complex.
The same behavior if file does not exist.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
