Uploaded image for project: 'Apache IoTDB'
  1. Apache IoTDB
  2. IOTDB-2646

Importing a CSV file through -batch, the accumulated value of multiple count data points in the CLI does not match it

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 0.12.5-SNAPSHOT
    • None
    • Tools/Others
    • None

    Description

      After importing the CSV file by using the -batch value parameter, entering the CLI, query the count data points multiple times, and find that the data points are not inserted in batches according to the -batch value.
      step 1: start server, import csv file
      bigdata.csv about 2.7G

      ./import-csv.sh -h 127.0.0.1 -p 6667 -u root -pw root -f ./bigdata.csv -batch 1000000 

      Step 2: Enter CLI, execute query

      select count(s_0) from root.data.g_0.d_0 

      Then like this:

       

       

      Attachments

        Issue Links

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            xuanronaldo Xuan Ronaldo
            xiaozhihong xiaozhihong
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment