#13456: Error on importing long varbinary datatype in vertica for Transaction type:Batch & Threshold

vaibhavladdha271(*) reported Jul 10, 2015 · SachinPrakash last modified Apr 10, 2017

Error on importing long varbinary datatype in vertica for Transaction type:Batch & Threshold

Dev	tomconrad
QA	tariqrahiman

Priority	Minor
Complexity	Unknown

Component	Tools - Import Tool
Version	18.0

Product: Aqua Data Studio

Version: 17.0.0-dev-74

Build #: 44661

Build Date: 2015-Jul-09 05:29:58 PM

Operating Environment: Linux (3.13.0-57-generic, amd64) / UTF-8 / en / IN / Oracle Corporation 1.8.0_40-b26

Memory: Max=704,643,072; Total=296,222,720; Free=126,323,648; CPUs=8

Steps to reproduce:
1)Create a table using below script:

CREATE TABLE "public"."longvarbinary_datatype" (

"c1" long varbinary(80)

)

GO
2)Insert a record in table using below script:

INSERT INTO "public"."longvarbinary_datatype"("c1")

VALUES('vaibhav123')

GO
3)Right click on created table & select Tools->export data.
Click on Next
4)Enter a file name
Select "Delimited data" from Format option.
Click on next.

Data is exported successfully in file.

Please refer test.csv for exported data.
5)Right click on created table in Tree node & select Tools->Import data option.
Select previously saved file.
Keep default settings as it is & click on Next.
Click on Next & again click on Next.
6)Select Batch from Transaction type field.

Click on Next.

Data does not get imported successfully & an error message:"Error: Row: 1 -- [Vertica][JDBC](10120) Error converting data, invalid type for parameter: 1.

SQL: INSERT INTO "public"."longvarbinary_datatype"("c1") VALUES(?)" is displayed.

Works fine for Transaction type:Full

5 attachments

test.csv

Jul 10, 2015

30 B
13456.png

Jul 10, 2015

172 KB
vertica_export.csv

Aug 23, 2016

30 B
13456_dev-207.png

Aug 23, 2016

142 KB
13456_dev-211.png

Aug 26, 2016

46 KB

All Comments (4) Change History

tomconrad Aug 22, 2016

svn# 50900

vaibhavladdha271(*) Aug 23, 2016 · (edited)

Reopening this issue as i'm getting Numberformatexception on importing csv file containing varbinary data.

1.Open attached vertica_export.csv

2.Right click on created table in Tree node & select Tools->Import data option.
Select vertica_export.csv file.
3.Keep default settings as it is & click on Next.
Click on Next & again click on Next.
4.Select Threshold from Transaction type field.

Click on Next

Actual result: Import message is displayed but data is not imported.Also numberformat exception is displayed in view log.

Refer attached screenshot(13456_dev-207.png)

java.lang.NumberFormatException: For input string: "76616962686176313233"

at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)

at java.lang.Integer.parseInt(Integer.java:583)

at java.lang.Integer.valueOf(Integer.java:766)

at \\.\\.\\हिñçêČάй語简�?한\\.w⣃ꌄꏬꍰ.a(Unknown Source)

at \\.\\.\\हिñçêČάй語简�?한\\.w⣃ꌄꏬꍰ.process(Unknown Source)

at \\.\\.\\हिñçêČάй語简�?한\\.w⣃ꌄꏬꍰ.run(Unknown Source)

tomconrad Aug 23, 2016

svn# 50909

vaibhavladdha271(*) Aug 26, 2016

Verified in dev-211.Refer attached screenshot(13456_dev-211.png)

Search Tips

Aqua Data Studio / nhilam

Error on importing long varbinary datatype in vertica for Transaction type:Batch & Threshold

5 attachments

Issue #13456

Completion

Search Tips

Aqua Data Studio / nhilam

Title

Error on importing long varbinary datatype in vertica for Transaction type:Batch & Threshold

5 attachments

Issue #13456

Completion