Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
1.2.5
-
None
Description
Asked by customer - Questions is is there an option -f for Colxml or is it just shown in the output run the colxml as shown in the Document example. And is the output correct based on what the custome is reporting.
/usr/local/mariadb/columnstore/bin/colxml tpch2 -j500
Running colxml with the following parameters:
2015-10-07 15:14:20 (9481) INFO :
Schema: tpch2
Tables:
Load Files:
-b 0
-c 1048576
-d |
-e 10
f CSV <------ here
From customer:
On this page
https://mariadb.com/kb/en/library/columnstore-bulk-data-loading/
In the section 'colxml syntax' there is no mention of the -f option.
When i do colxml -h on my system there is no mention of a -f option.
On the referenced page in the next section there is an example that contains '-f CSV'
yet the delimiter is shown as a pipe and the file extension as tbl
./colxml -h
Usage: colxml [options] dbName
Options:
-d Delimiter (default '|')
-e Maximum allowable errors (per table)
-h Print this message
-j Job id (numeric)
-l Load file name
-n "name in quotes"
-p Path for XML job description file that is generated
-s "Description in quotes"
-t Table name
-u User
-r Number of read buffers
-c Application read buffer size (in bytes)
-w I/O library buffer size (in bytes), used to read files
-x Extension of file name (default ".tbl")
-E EnclosedByChar (if data has enclosed values)
-C EscapeChar
-b Debug level (1-3)
dbName - Required parm specifying the name of the database;
all others are optional
Example:
colxml -t lineitem -j 123 tpch