You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "xuyali (JIRA)" <ji...@apache.org> on 2016/11/24 08:27:58 UTC

[jira] [Created] (DRILL-5067) AssertionError when connect to mysql and query element of a varchar-type json column

xuyali created DRILL-5067:
-----------------------------

             Summary: AssertionError when connect to mysql and query element of a varchar-type json column 
                 Key: DRILL-5067
                 URL: https://issues.apache.org/jira/browse/DRILL-5067
             Project: Apache Drill
          Issue Type: Bug
          Components: Storage - JSON
    Affects Versions: 1.8.0
            Reporter: xuyali


Steps:
1.Install drill 1.8.0 to the mysql server.
2.copy mysql-jdbc-connector jar to jars/3rdparty.
3.start embedded drill : bin/drill-embedded.
4.configure a mysql storage on the web console.
5.I use a sql as below:
select tb1.json_record.name from tb1 limit 100;
note:json_record is a column defined as "varchar",and there's a element called name in the json_record data structure.
then I got a error:
Error: SYSTEM ERROR: AssertionError: VARCHAR


[Error Id: a75b1588-150f-4fce-bd79-db63b9be468d on iZ25hwmeccrZ:31010] (state=,code=0)




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)