Can not connect to HAWQ(hadoop) database

[iketomo0324]

Hi all,

if you know, please help me.

i want to use HAWQ(hadoop) database as data souce.

i can't select HAWQ database as data souce  (there are not), so i select PostgreSQL as data souce, then i can connect HAWQ.

but  when i select table name in navigation window,  error is displayed.

----------------------------------------------------------------------------------------------

DataSource.Error: PostgreSQL: 0AM01: Cannot support unlisten statement yet
    DataSourceKind=PostgreSQL
    DataSourcePath=192.168.1.***;databasename
    Message=0AM01: Cannot support unlisten statement yet
    ErrorCode=-2147467259

----------------------------------------------------------------------------------------------

how do i HAWQ will be used ? ( i can't use HAWQ as data souce?)

[iketomo0324 · Accepted solution]

Hi all,

I've solved.

i do not use native-connect.
i succeed to connect to hawq useing odbc.

thanks.

[Anonymous]

Were you satisfied when accessing HAWQ using ODBC? I'm looking for a more native solution (maybe based on npgsql/postgreSQL drivers) as they're usually better performance-wise. ODBC is really slow. And I even didn't get to limitations on memory size.

[wmorris20]

Hi, are you able to share details of your solution?  Did you use Kerberos or some other authentication method with ODBC?