[DRILL-8125] jdbc postgresql & null JSONB fields

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 1.20.1
• Component/s: Storage - JDBC
• Assignee: Unassigned
• Reporter: Matteo Redaelli
• Created: 05/Feb/22 17:48
• Updated: 12/Jul/22 06:44

Description

Using streamline, psql, sqlline via jdbc/postgres I can query a postgres table

select instance_id, tags from aws_prd.aws_ec2_instance limit 1;

instance_id  i-0xxx
tags         {"Name": "talend-engine-01", ...}

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

 

With drill command  line (drill-embeeded) I get null value for "tags" fields

apache drill> select instance_id, tags from steampipe.aws_dm_prd.aws_ec2_instance limit 1;

instance_id  i-0xxx
tags         null