Attach pre-made ORC files about cstore_fdw HOT 4 CLOSED

Do you mean ORC files created by Hive? We don't have plans to support Hive's ORC files.

You can reattach files pre-made by cstore_fdw to other tables by setting the appropriate filename.

What is your use-case here?

from cstore_fdw.

Yes, Hive ORC files was what I had in mind. Where are the docs for reattaching cstore_fdw-made ORC files? Is this worked into pg_dump?

Anyhow, my actual use case is broader: attaching to existing Hive (or the underlying Hadoop/HDFS/etc., whichever is simpler to accomplish) with PostgreSQL.

from cstore_fdw.

Sorry for replying so late.

For attaching cstore_fdw-made files, assuming that your file is at /path/to/cstore/file, you can do:

CREATE FOREIGN TABLE attached_cstore_table(column_list)
SERVER cstore_server
OPTIONS (filename '/path/to/cstore/file');

For attaching Hive ORC files, we don't have any official solutions yet. You can take a look at orc_fdw which tries to wrap around Hive ORC files, but I think that project is not finished yet and isn't very easy to use.

from cstore_fdw.

We don't have any plans to support Hive's ORC files, and if we do it will be done as a separate project, so I am closing this issue.

from cstore_fdw.