Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.