I'm relatively new to this community and also Tableau itself. Would appreciate if someone could help me with this problem. I'm trying to connect my Tableau desktop to a Pivotal HD (HAWQ) Database. Connection is successful, tables and structure can be seen and I used Data Direct 7.1 Greenplum Wire. Apparently, when I dragged the tables identified to show or view sample data, this error comes outs:
[DataDirect][ODBC Greenplum Wire Protocol driver][HAWQ]Error: cannot cast type "table name" to character varying(Position 138;File parse_expr.c;Line 2738;Routine typecast_expression;)
Below are some screenshots:
Hope someone could help me
We were able to make this work by changing connectivity. ODBC Other Database > Data Direct 7.1 Greenplum Wire has problems or issues with HAWQ in parsing data. We used the native Pivotal Greenplum Database connectivity instead of the ODBC Other Databases > DataDirect 7.1.