Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Exported Insert.sql column type error #5

Open
zifeishan opened this issue Jan 23, 2015 · 0 comments
Open

Exported Insert.sql column type error #5

zifeishan opened this issue Jan 23, 2015 · 0 comments

Comments

@zifeishan
Copy link

For the generated insert.sql file, the column types for labels should be BOOLEAN but it is generated as TEXT. This causes error on Greenplum.

$ psql $DBNAME < insert.sql
NOTICE:  table "tags_precision_m_claim_type_v1" does not exist, skipping
DROP TABLE
NOTICE:  Table doesn't have 'DISTRIBUTED BY' clause -- Using column named 'doc_id' as the Greenplum Database data distribution key for this table.
HINT:  The 'DISTRIBUTED BY' clause determines the distribution of data. Make sure column(s) chosen are the optimal data distribution key to minimize skew.
CREATE TABLE
ERROR:  column "is_correct" is of type text but expression is of type boolean
LINE 2: ("doc_id", "mention_id", "is_correct", ...
                                 ^
HINT:  You will need to rewrite or cast the expression.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants