Обсуждение: PostgreSQL drivers support for Accessing HAWQ Data.
PostgreSQL drivers support for Accessing HAWQ Data.
От
"Pasupunooti, Kiran Kumar (GE, Appl & Light, consultant)"
Дата:
Hello,
Am trying to access Data located in HAWQ into SAS 9.2 on Solaris 10 environment.
Does these drivers support to get the data from HAWQ into SAS.
Please advice
I have installed the drivers from below link
http://www.postgresql.org/ftp/odbc/versions/src/
Thank you
Kiran
On 04/02/2015 07:46 AM, Pasupunooti, Kiran Kumar (GE, Appl & Light, consultant) wrote: > Hello, > > Am trying to access Data located in HAWQ into SAS 9.2 on Solaris 10 > environment. > > Does these drivers support to get the data from HAWQ into SAS. I know what SAS is, I am not sure I fully understand what HAWQ is? I starting with the assumption you are talking about this: http://pivotal.io/big-data/white-paper/a-true-sql-engine-for-hadoop-pivotal-hd-hawq From a quick read it seems to interface with Hadoop. I see references to Greenplum, but am not sure how they apply. I think we will need a more detailed explanation of what you are doing, in particular where Postgres fits into this. > > Please advice > > I have installed the drivers from below link > > http://www.postgresql.org/ftp/odbc/versions/src/ > > Thank you > > Kiran > -- Adrian Klaver adrian.klaver@aklaver.com
On 04/06/2015 12:44 PM, Pasupunooti, Kiran Kumar (GE, Appl & Light, consultant) wrote: > Hi Adrian Klaver, > > I don't have clarity exactly on HAWQ, you should know since its Pivotal product. > We have our data located in HAWQ, some of our users want to pull the tables from HAWQ into SAS. > SAS does not have its HAWQ drivers to pull data from HAWQ into SAS, > I heard Pivotal HAWQ supports drivers Green plum and PostgreSQL drivers to pull the data. > I have already tested the Greenplum ODBC drivers, and I was able to pull data from HAWQ into SAS. > But while testing I have used EVAL the evaluation copy when it asked Serial Number and key fields. > By any chance can I get the serial number and key fields for the licensed copy for Green plum drivers. Not without paying for, I am sure. According to here you should be able to use the standard ODBC drivers: http://hawq.docs.pivotal.io/docs-gpdb/admin_guide/access_db/topics/g-supported-client-applications.html using these parameters: http://hawq.docs.pivotal.io/docs-gpdb/admin_guide/access_db/topics/g-establishing-a-database-session.html In fact you are supposed to be able to connect using psql, so I would try that first as a test. > And also can you tell me whether Pivotal HAWQ ODBC drivers supports to pull data from HAWQ into SAS. Pivotal says yes: http://hawq.docs.pivotal.io/docs-gpdb/admin_guide/access_db/topics/g-third-party-client-tools.html#topic13 > > > > -----Original Message----- > From: Adrian Klaver [mailto:adrian.klaver@aklaver.com] > Sent: Monday, April 06, 2015 3:29 PM > To: Pasupunooti, Kiran Kumar (GE, Appl & Light, consultant); pgsql-odbc@postgresql.org > Subject: Re: [ODBC] PostgreSQL drivers support for Accessing HAWQ Data. > > On 04/02/2015 07:46 AM, Pasupunooti, Kiran Kumar (GE, Appl & Light, > consultant) wrote: >> Hello, >> >> Am trying to access Data located in HAWQ into SAS 9.2 on Solaris 10 >> environment. >> >> Does these drivers support to get the data from HAWQ into SAS. > > I know what SAS is, I am not sure I fully understand what HAWQ is? > > I starting with the assumption you are talking about this: > > http://pivotal.io/big-data/white-paper/a-true-sql-engine-for-hadoop-pivotal-hd-hawq > > From a quick read it seems to interface with Hadoop. I see references to Greenplum, but am not sure how they apply. Ithink we will need a more detailed explanation of what you are doing, in particular where Postgres fits into this. > > >> >> Please advice >> >> I have installed the drivers from below link >> >> http://www.postgresql.org/ftp/odbc/versions/src/ >> >> Thank you >> >> Kiran >> > > > -- > Adrian Klaver > adrian.klaver@aklaver.com > -- Adrian Klaver adrian.klaver@aklaver.com
Re: PostgreSQL drivers support for Accessing HAWQ Data.
От
"Pasupunooti, Kiran Kumar (GE, Appl & Light, consultant)"
Дата:
Hi Adrian Klaver, I don't have clarity exactly on HAWQ, you should know since its Pivotal product. We have our data located in HAWQ, some of our users want to pull the tables from HAWQ into SAS. SAS does not have its HAWQ drivers to pull data from HAWQ into SAS, I heard Pivotal HAWQ supports drivers Green plum and PostgreSQL drivers to pull the data. I have already tested the Greenplum ODBC drivers, and I was able to pull data from HAWQ into SAS. But while testing I have used EVAL the evaluation copy when it asked Serial Number and key fields. By any chance can I get the serial number and key fields for the licensed copy for Green plum drivers. And also can you tell me whether Pivotal HAWQ ODBC drivers supports to pull data from HAWQ into SAS. -----Original Message----- From: Adrian Klaver [mailto:adrian.klaver@aklaver.com] Sent: Monday, April 06, 2015 3:29 PM To: Pasupunooti, Kiran Kumar (GE, Appl & Light, consultant); pgsql-odbc@postgresql.org Subject: Re: [ODBC] PostgreSQL drivers support for Accessing HAWQ Data. On 04/02/2015 07:46 AM, Pasupunooti, Kiran Kumar (GE, Appl & Light, consultant) wrote: > Hello, > > Am trying to access Data located in HAWQ into SAS 9.2 on Solaris 10 > environment. > > Does these drivers support to get the data from HAWQ into SAS. I know what SAS is, I am not sure I fully understand what HAWQ is? I starting with the assumption you are talking about this: http://pivotal.io/big-data/white-paper/a-true-sql-engine-for-hadoop-pivotal-hd-hawq From a quick read it seems to interface with Hadoop. I see references to Greenplum, but am not sure how they apply. I thinkwe will need a more detailed explanation of what you are doing, in particular where Postgres fits into this. > > Please advice > > I have installed the drivers from below link > > http://www.postgresql.org/ftp/odbc/versions/src/ > > Thank you > > Kiran > -- Adrian Klaver adrian.klaver@aklaver.com