Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-3562

colxml parameter question

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 1.2.5
    • Icebox
    • Documentation
    • 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

      Attachments

        Activity

          People

            David.Hall David Hall (Inactive)
            hill David Hill (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.