• tmp for cassandra batch delete


    now i have no time to verify this bash script. it is hard for me to delete each data via primary key 

    #!/bin/bash

    if [[ ${1} == "" ]];then
    echo "Please indicate the cassandra Address."
    echo "Use this cmd like this:"
    echo "./clear_data.sh 192.102.1.1"
    exit
    fi;

    arr=(`cqlsh ${1} -f list_tables.cmd`)

    echo "table list: ${arr[*]}"

    for((i=0; i<${#arr[@]}; i++));do
    count=(`cqlsh ${1} -e "use clicki_v4; select count(*) from ${arr[i]};"`)
    #echo ${count[*]}
    echo "before truncate table, there are ${count[2]} rows in table ${arr[i]};"
    #====================================
    #NOTE: dangerous command, please seriously check!!!!!!
    cqlsh ${1} -e "use clicki_v4; truncate ${arr[i]};"
    #====================================
    count=(`cqlsh ${1} -e "use clicki_v4; select count(*) from ${arr[i]}"`)
    echo "after truncate table, there are ${count[2]} rows in table ${arr[i]};"
    done;


    --目前就一个库clicki_v4,后续可以继续增加...
    use clicki_v4;
    desc tables;

    CREATE TABLE coach_uat.mytable (
    uid text,
    id int,
    name text,
    PRIMARY KEY (uid),
        );

    CREATE TABLE coach_uat.mytable(
      key1 text,
      key2 text,
      key3 text,
      column1 bigint,
      column2 int,
      column3 timestamp,
    primary key(key1, key2, key3);
        )

  • 相关阅读:
    利用FT232实现USB转串口
    用例图
    Flash与EEPROM
    spring -boot定时任务 quartz 基于 MethodInvokingJobDetailFactoryBean 实现
    得到中文首字母
    删除目录
    数字格式化工具
    Md5加密
    Double类型的数值 在写入excel时 如何去掉 科学计算法的 后面数值+ E的 情况
    数值的比较
  • 原文地址:https://www.cnblogs.com/qianjinyan/p/9182285.html
Copyright © 2020-2023  润新知