You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Francesco Boscarino (JIRA)" <ji...@apache.org> on 2016/09/07 12:26:20 UTC
[jira] [Created] (DRILL-4881) JSON parsing of MySQL TEXT field
Francesco Boscarino created DRILL-4881:
------------------------------------------
Summary: JSON parsing of MySQL TEXT field
Key: DRILL-4881
URL: https://issues.apache.org/jira/browse/DRILL-4881
Project: Apache Drill
Issue Type: Bug
Components: Client - CLI
Affects Versions: 1.8.0
Environment: Linux
Java 1.8
Reporter: Francesco Boscarino
I have a MySQL table with a TEXT field with a JSON string and I would like to query this table filtering on field value inside JSON.
I tried first a SELECT All in this form:
SELECT *,CONVERT_FROM(config,'JSON') FROM MyTable
But, has I have for the same JSON field, different data types, I always got the error:
You tried to write a VarChar type when you are using a ValueWriter of type NullableBigIntWriterImpl
and similar (BigInt for example).
I tried changing the option store.json.all_text_mode and/or store.json.read_numbers_as_double but it seems the options are used only if reading from JSON files and not from CONVERT_FROM.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)