Skip to content

Schema-Import-Tool.md

Latest commit

 

History

History
82 lines (64 loc) · 3.67 KB

Schema-Import-Tool.md

File metadata and controls

82 lines (64 loc) · 3.67 KB
Raw

Metadata Import

1. Overview

The metadata import tool import-schema.sh/bat is located in the tools directory. It can import CSV files containing metadata creation statements from a specified path into IoTDB.

Supported since version 1.3.3

2. Detailed Functionality

2.1 Parameter Description

Short Parameter Full Parameter Description Required Default Value
-h --host Hostname No 127.0.0.1
-p --port Port number No 6667
-u --username Username No root
-pw --password Password No root
-s --source Local path of the script file or directory to be loaded Yes -
-fd --fail_dir Specifies the directory to save failed files No -
-lpf --lines_per_failed_file Specifies the maximum number of lines per failed file No 100000. Range: 0 ~ Integer.MAX_VALUE = 2147483647
-help --help Displays help information No -

2.2 Execution Commands

# Unix/OS X
tools/import-schema.sh [-h <host>] [-p <port>] [-u <username>] [-pw <password>] -s
       <sourceDir/sourceFile> [-fd <failDir>] [-batch <batchSize>] [-lpf <linesPerFile>] [-help]
      
# Windows
tools\import-schema.bat [-h <host>] [-p <port>] [-u <username>] [-pw <password>] -s
       <sourceDir/sourceFile> [-fd <failDir>] [-batch <batchSize>] [-lpf <linesPerFile>] [-help]

2.3 Usage Example

-- Before import
IoTDB> show timeseries root.ln.**
+----------+-----+--------+--------+--------+-----------+----+----------+--------+------------------+--------+
|Timeseries|Alias|Database|DataType|Encoding|Compression|Tags|Attributes|Deadband|DeadbandParameters|ViewType|
+----------+-----+--------+--------+--------+-----------+----+----------+--------+------------------+--------+
+----------+-----+--------+--------+--------+-----------+----+----------+--------+------------------+--------+
# Execute the import command
./import-schema.sh -s /home/dump0_0.csv
-- Verify after successful import
IoTDB> show timeseries root.ln.**
+--------------------------+-----+--------+--------+--------+-----------+----+----------+--------+------------------+--------+
|                Timeseries|Alias|Database|DataType|Encoding|Compression|Tags|Attributes|Deadband|DeadbandParameters|ViewType|
+--------------------------+-----+--------+--------+--------+-----------+----+----------+--------+------------------+--------+
|  root.ln.wf02.wt02.status| null| root.ln| BOOLEAN|     RLE|        LZ4|null|      null|    null|              null|    BASE|
|root.ln.wf02.wt02.hardware| null| root.ln|    TEXT|   PLAIN|        LZ4|null|      null|    null|              null|    BASE|
+--------------------------+-----+--------+--------+--------+-----------+----+----------+--------+------------------+--------+