We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Empty copy from local to temporary table — Vertica Forum

Empty copy from local to temporary table

Hello.
I try to load csv file in temporary table using ODBC.
For example, i use isql:
SQL> CREATE TEMPORARY TABLE qtest_tmp(id INT PRIMARY KEY, str VARCHAR(250));
SQLRowCount returns 4294967295
SQL> COPY qtest_tmp FROM LOCAL 'file.csv' DELIMITER ';' NULL '';
SQLRowCount returns 3
SQL> SELECT * FROM qtest_tmp;
+---------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| id                  | str                                                                                                                                                                                                                                                       |
+---------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+---------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
SQLRowCount returns 0
SQL>
'file.csv' contents:
0;str0
1;str1
2;str2
I get same mournful result if use ODBC C api.

BUT. If i use vsql, then everything is ok, and i load data successfully.


Please, help me...




 Loading...

Comments

  • Given that this post is 6 months old, I would hope you have worked past it. But, in any case, try using :
    on commit preserve rows 

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file