[jira] [Created] (DRILL-4881) JSON parsing of MySQL TEXT field

[Francesco Boscarino (JIRA)]

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)