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

can't import a file to exist table by cpimport

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Not a Bug
    • 1.0.9
    • Icebox
    • cpimport
    • None
    • Single Server (CentOS 7.3)

    Description

      I setup MariaDB ColumnStore environment as "Single Server".

      I get dump file from below site, and try to import it by cpimport.
      However "'wiki_test.page_counts' does not exist in Columnstore." error happened
      even I created database and table.

      https://dumps.wikimedia.org/other/pagecounts-raw/2016/2016-05/

      pm1# gunzip -r pagecounts-2016050*
      pm1# ls -lh pagecounts-2016050*
      -rwxr-xr-x. 1 root root 353M May 17 15:58 pagecounts-20160501-000000
      ...
      pm1# head pagecounts-20160501-000000
      aa Category:Language_user_templates 1 6020
      aa File:Hitchhicking_on_the_road_132_-_Gasp%C3%A9sie_Canada.jpg 1 8520
      ...

      pm1# mcsmysql
      MariaDB [(none)]> create database wiki_test;
      MariaDB [(none)]> use wiki_test;
      MariaDB [wiki_test]> create table page_counts (domain_code varchar(30), page_title text, count_views int unsigned, total_response_size int unsigned);
      MariaDB [wiki_test]> exit

      pm1# cpimport wiki_test page_counts ./pagecounts-20160501-000000 -s "\s"
      Locale is : C
      Column delimiter : \

      Unable to set default JobID; Error getting OID for table wiki_test.page_counts: IDB-2006: 'wiki_test.page_counts' does not exist in Columnstore.

      Attachments

        Activity

          People

            Unassigned Unassigned
            y-taka y-taka
            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.