Vertica's COPY Statement is not working in MATLAB
조회 수: 1 (최근 30일)
이전 댓글 표시
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
답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Database Toolbox에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!