Install on mac, doesn't create the cstore file and can't insert or analyze about cstore_fdw HOT 8 CLOSED

BTW I installed citusdb on a virtual machine as per the instructions. Imported my own data into my own table, the \STAGE command seemed to go OK but I can't select from the table

select * from probes limit 1;
ERROR: XX000: cache lookup failed for function 0
LOCATION: get_func_rettype, lsyscache.c:1439

from cstore_fdw.

@timuckun
I have some questions:

1. Did you run ANALYZE on a distributed table or a local table? Currently, you need to load data into the table before being able to query it or ANALYZE it. File gets created when COPY is run. We are planning to fix this bug in the next minor release.
2. What was your table schema? More specifically, what was the type of your partition column? There is a bug in CitusDB which happens at tables with partition columns of type varchar or composite or some other column types. If the partition column type was varchar, can you try replacing it with "text" type?

from cstore_fdw.

Ah yes the partition column was varchar. I'll redo the table when I get into the office tomorrow. Are there any downsides to using text instead of char or varchar?

from cstore_fdw.

I don't think so, unless you want the DBMS to do the length constraint check. The documentation says that there is no or little performance difference between text, char, and varchar.

update. Even their internal storage seems to be almost exactly the same. Compare bpchar_input and cstring_to_text_with_len.

from cstore_fdw.

Using the FDW.

Attempting to copy gives me this error

ERROR:  copy column list is not supported

********** Error **********

ERROR: copy column list is not supported
SQL state: 0A000

So I have had to recreate the table so that the fields are in the same order as the text file.

from cstore_fdw.

I added copy from column list to our internal roadmap. We need to prioritize tasks to see when we can get this done.

from cstore_fdw.

This issue is addressed in #29 which just got checked into the develop branch. I hope to merge the branch into the master branch in a month.

from cstore_fdw.

This issue has been resolved with the cstore_fdw v1.1 release. cstore_fdw now creates an empty data file and the appropriate footer file with CREATE FOREIGN TABLE. So, running analyze or issuing queries on an empty table would work.

Closing this issue as the issue relating to copy column list is being discussed in #30 .

from cstore_fdw.