[jira] [Created] (DRILL-8125) jdbc postgresql & null JSONB fields

["Matteo Redaelli (Jira)" <ji...@apache.org>]

Matteo Redaelli created DRILL-8125:
--------------------------------------

             Summary: jdbc postgresql & null JSONB fields
                 Key: DRILL-8125
                 URL: https://issues.apache.org/jira/browse/DRILL-8125
             Project: Apache Drill
          Issue Type: Bug
          Components: Storage - JDBC
            Reporter: Matteo Redaelli


Using streamline, psql, sqlline via jdbc/postgres I can query a postgres table
{noformat}
select instance_id, tags from aws_prd.aws_ec2_instance limit 1;

instance_id  i-0xxx
tags         {"Name": "talend-engine-01", ...}{noformat}
{noformat}
 select instance_id, tags -> 'Name' from aws_dm_prd.aws_ec2_instance limit 1; 
 
instance_id  i-0xxx 
?column?    "talend-engine-01"
{noformat}
 

With drill command  line (drill-embeeded) I get null value for "tags" fields
{noformat}
apache drill> select instance_id, tags from steampipe.aws_dm_prd.aws_ec2_instance limit 1;

instance_id  i-0xxx
tags         null{noformat}
 



--
This message was sent by Atlassian Jira
(v8.20.1#820001)