我正在使用Datastax Cassandra3.0,而使用cqlsh架构在cassandra中创建表正在改变列名正在按照字母顺序排列 . 请看下面 .
这是创建表时的结构..
cqlsh> CREATE TABLE tutorialspoint.SupplierItemData_input15(partnumber BIGINT PRIMARY KEY,
...供应商文字,
... monthyear varchar,
...分配int,
......日期,
... paymentterms int,
... actualdays int,
... percentofpayment int,
...变化int,
... paymenttermsummary text,
... copq int,
...年int,
...月int,
...发布日期);
但是当我检查DESCRIBE TABLE NAME时,结构正在发生变化
cqlsh> DESCRIBE tutorialspoint.SupplierItemData_input15;
CREATE TABLE tutorialspoint.supplieritemdata_input15(
partnumber bigint PRIMARY KEY,
actualdays int,
分配int,
copq int,
到期日,
月int,
一年的文字,
paymentterms int,
paymenttermsummary text,
percentofpayment int,
发布日期,
供应商文字,
变异int,
年int
)
WITH bloom_filter_fp_chance = 0.01
AND caching = {'keys':'ALL','rows_per_partition':'NONE'} AND comment =''AND compaction = {'class':'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy','max_threshold' :'32','min_threshold':'4'} AND compression = {'chunk_length_in_kb':'64','class':'org.apache.cassandra.io.compress.LZ4Compressor'} AND crc_check_chance = 1.0 AND dclocal_read_repair_chance = 0.1 AND default_time_to_live = 0 AND gc_grace_seconds = 864000 AND max_index_interval = 2048 AND memtable_flush_period_in_ms = 0 AND min_index_interval = 128 AND read_repair_chance = 0.0 AND speculative_retry = '99PERCENTILE';
请帮帮我 .
谢谢拉维
1 回答
如果要从csv文件使用cqlsh COPY导入数据,则应将列名添加为csv文件顶部的 Headers . 这样,默认情况下它们的顺序无关紧要 .