[ https://issues.apache.org/jira/browse/DRILL-8125?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17487620#comment-17487620 ]
Cong Luo commented on DRILL-8125: --------------------------------- [~matteoredaelli] Hi. Are there any error messages in the log? > 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 > 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.1#820001)