Fetch temporary tables data of PostgreSQL from Apache Drill

[ja...@accenture.com]

Hi,

I am able to fetch normal tables data from PostgreSQL using Apache Drill but not able to get the data of temporary tables.

Is there any way how to fetch data from temporary tables?

Regards,
Jasbir Singh

________________________________

This message is for the designated recipient only and may contain privileged, proprietary, or otherwise confidential information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the e-mail by you is prohibited. Where allowed by local law, electronic communications with Accenture and its affiliates, including e-mail and instant messaging (including content), may be scanned by our systems for the purposes of information security and assessment of internal compliance with Accenture policy.
______________________________________________________________________________________

www.accenture.com

Re: Fetch temporary tables data of PostgreSQL from Apache Drill

[Khurram Faraaz <kf...@mapr.com>]

Temporary tables are session specific, how are you trying to access them from Drill ?


If the temporary table was created in Postgres in a different session, you can not access that temporary table from Drill using another session. Temporary tables get dropped once session terminates.


Thanks,

Khurram

________________________________
From: jasbir.sing@accenture.com <ja...@accenture.com>
Sent: Tuesday, April 18, 2017 2:32:51 PM
To: user@drill.apache.org
Subject: Fetch temporary tables data of PostgreSQL from Apache Drill

Hi,

I am able to fetch normal tables data from PostgreSQL using Apache Drill but not able to get the data of temporary tables.

Is there any way how to fetch data from temporary tables?

Regards,
Jasbir Singh

________________________________

This message is for the designated recipient only and may contain privileged, proprietary, or otherwise confidential information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the e-mail by you is prohibited. Where allowed by local law, electronic communications with Accenture and its affiliates, including e-mail and instant messaging (including content), may be scanned by our systems for the purposes of information security and assessment of internal compliance with Accenture policy.
______________________________________________________________________________________

www.accenture.com<http://www.accenture.com>