Vertica's COPY Statement is not working in MATLAB

조회 수: 1 (최근 30일)
Hariprasad
Hariprasad 2016년 3월 28일
편집: Walter Roberson 2016년 3월 28일
I'm trying to use the COPY statement available in Vertica to load data from a file into Vertica database table but I'm getting an error
'[Vertica][JDBC](11300) A ResultSet was expected but not generated from query "COPY myschema.mytable (FK_CUSTOMER_ID,FK_START_DATE_ID,FK_END_DATE_ID,FK_TRAVEL_ID,FK_ORIGIN_ID,FK_DEST_ID,FK_SEGMENT_ID, SEGMENT_PERCENTAGE,LAST_UPDATED) FROM LOCAL ''/my/full/path/to/file/test2.dat'' DELIMITER '',''". Query not executed. '
I'm trying to run this query from my local machine to linux server where the Vertica database is. Same query when run on sql client connected to vertica database, it runs perfectly and loads the data into the table.
I do not understand why it is not working in MATLAB. The database connection is also proper since I used the same connection settings to load data using datainsert. Any idea what I'm missing here? The query has to be:
COPY myschema.mytable (FK_CUSTOMER_ID, FK_START_DATE_ID, FK_END_DATE_ID, FK_TRAVEL_ID,FK_ORIGIN_ID, FK_DEST_ID, FK_SEGMENT_ID, SEGMENT_PERCENTAGE, LAST_UPDATED) FROM LOCAL '/Fullpath/to/file/test2.dat' DELIMITER ',' ;

답변 (0개)

카테고리

Help CenterFile Exchange에서 Database Toolbox에 대해 자세히 알아보기

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by