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)
