Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Result JSON unsupported types #393

Open
gruuya opened this issue May 9, 2023 · 0 comments
Open

Result JSON unsupported types #393

gruuya opened this issue May 9, 2023 · 0 comments

Comments

@gruuya
Copy link
Contributor

gruuya commented May 9, 2023

Arrow JSON writer that we use to format the output result of queries does not support all data types that Datafusion handles. For example:

$ curl -H "Content-Type: application/json" http://localhost:8080/q -d@-<<EOF
{"query": "CREATE TABLE test_table(dec_column NUMERIC, float_column REAL); SELECT column_name, data_type FROM information_schema.columns WHERE table_name = 'test_table'"}
EOF
{"column_name":"dec_column","data_type":"Decimal128(38, 10)"}
{"column_name":"float_column","data_type":"Float32"}
$ curl -H "Content-Type: application/json" http://localhost:8080/q -d@-<<EOF
{"query": "INSERT INTO test_table (float_column) VALUES (42.0); SELECT * FROM test_table"}
EOF
Arrow error: Json error: data type Decimal128(38, 10) not supported in nested map for json writer
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant