1 Reply Latest reply on Mar 2, 2015 8:48 PM by RAMIL TRINIDAD

    Error in retrieving data from HAWQ (Pivotal HD)

    RAMIL TRINIDAD

      Hi,

       

          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:

       

      hawq_error_1.PNG

      hawq_error_2.PNG

       

      Hope someone could help me

       

      Thanks!

      RAMIL