[
https://issues.apache.org/jira/browse/DRILL-8125?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
James Turton updated DRILL-8125:
--------------------------------
Affects Version/s: 1.20.1
> 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
> Affects Versions: 1.20.1
> Reporter: Matteo Redaelli
> Priority: Minor
>
> 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.10#820010)
