hawq-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Muji Kadry <mujtaba.qa...@gmail.com>
Subject Creating view on Hcatalog Tables
Date Wed, 07 Sep 2016 19:58:01 GMT
Hi All,

I am running a POC, in which the customer wants to access HAWQ data stored
in ORC format via PXF in HAWQ, without changing their existing queries. In
order to do that i was thinking of creating a view on top of the hcatalog
tables, but hawq is giving error. Does anyone else have any other ideas on
how to circumvent changing tables names?

Thanks,
Muji

For Example:

gpadmin=# create view  vw_time_dim as

gpadmin-#

gpadmin-# select time_id from hcatalog.default.time_dim;

server closed the connection unexpectedly

This probably means the server terminated abnormally

before or while processing the request.

The connection to the server was lost. Attempting reset: Failed.

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message