Cassandra server log location in the $CASSANDRA_HOME/conf/log4j-server.properties file to the log to the cassandra-data directory you created earlier: $ sed -i -e "s,log4j.appender.R.File=/var/log/cassandra/system /system.log, \ log4j.appender.R.File=$HOME/datastax/cassandra-data/system.log," \ $CASSANDRA_HOME/conf/log4j-server.properties 3. Configure the DataStax demo application to point to the correct Cassandra Community would be: tar –xzvf dsc-cassandra-1.0.7-bin.tar.gz. 3. If you want to take the default data and log file locations for Cassandra, you can proceed to starting up Cassandra by going to the bin directory

. . . . . . . . . . . . . . . . . . . . . . . . . . . 337 BenchmarkSQL 5.0 PostgreSQL statement list . . . . . . . . . . . . . . . . . . . . 340 6.7 Module Test . . . . . . . . . . . . . . . . . . ShardingSphere became an Apache Top‐Level Project on April 16, 2020. You are welcome to check out the mailing list and discuss via mail. 1.2 Design Philosophy ShardingSphere adopts the database plus design philosophy ShardingSphere document, v5.2.0 ${latest.release.version} Notice: Please change ${latest.release.version} to the actual version. 3. Edit application.yml. spring: shardingsphere:

. . . . . . . . . . . . . . . . . . . . . . . . . . . 364 BenchmarkSQL 5.0 PostgreSQL statement list . . . . . . . . . . . . . . . . . . . . 367 6.7 Module Test . . . . . . . . . . . . . . . . . . ShardingSphere became an Apache Top‐Level Project on April 16, 2020. You are welcome to check out the mailing list and discuss via mail. 1.5. Roadmap 9 2 Quick Start In shortest time, this chapter provides users ShardingSphere document, v5.2.1 ${latest.release.version} Notice: Please change ${latest.release.version} to the actual version. 3. Edit application.yml. spring: shardingsphere:

table_reference tbl_name [AS] alias] [index_hint_list] | table_reference ([INNER] | {LEFT|RIGHT} [OUTER]) JOIN table_factor [JOIN ON conditional_expr | USING (column_list)] 子查询 子查询和外层查询同时指定分片键，且分片键的值保持一致时，由内核提供稳定支持。 apache.shardingsphere.sharding.api.config.ShardingTableRuleConfiguration 可配置属性： 名称 数据类型 说明 默认值 log icTable String 分片逻辑表名称 • a ctualDa taNodes (?) String 由数据源名 + 表名组成， 以小数点分隔。多个表 以逗号分隔，支持行表 达式 使用已知数据源与逻辑 trategyConfiguration 可配置属性： 名称 数据类型 说明 writeDataSourceName String 写库数据源名称 readDataSourceNames List 读库数据源列表 类名称：org.apache.shardingsphere.readwritesplitting.api.strategy.DynamicReadwriteSp

Constraints 526 Dropping a Time-based Restriction 526 Auditing 526 Viewing the Database Server Log Files 527 Encrypting Data and Database Connections 530 Encrypting gpfdist Connections 531 Encrypting Database with a Different Owner 548 VMware Greenplum 6 Documentation VMware, Inc 22 Viewing the List of Databases 548 Altering a Database 548 Dropping a Database 549 Creating and Managing Tablespaces 576 Defining Date Range Table Partitions 577 Defining Numeric Range Table Partitions 578 Defining List Table Partitions 578 Defining Multi-level Partitions 578 Partitioning an Existing Table 579 Limitations

Constraints 505 Dropping a Time-based Restriction 506 Auditing 506 Viewing the Database Server Log Files 507 Encrypting Data and Database Connections 510 Encrypting gpfdist Connections 511 Encrypting Database 527 Cloning a Database 528 Creating a Database with a Different Owner 528 Viewing the List of Databases 528 Altering a Database 528 Dropping a Database 529 Creating and Managing Tablespaces 555 Defining Date Range Table Partitions 556 Defining Numeric Range Table Partitions 557 Defining List Table Partitions 557 Defining Multi-level Partitions 557 Partitioning an Existing Table 558 Limitations

TiDB cluster status· · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · 177 4.5.2 Log in to the database and perform simple operations· · · · · · · · · · · · · · · 180 4.6 Test Cluster · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · 381 6.7.1 View the cluster list· · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · 382 6.7.2 · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · 506 8.1.7 7. Common log analysis · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · 511 8.2 Identify

Constraints 531 Dropping a Time-based Restriction 531 Auditing 531 Viewing the Database Server Log Files 532 Encrypting Data and Database Connections 535 Encrypting gpfdist Connections 536 Encrypting Database 552 Cloning a Database 553 Creating a Database with a Different Owner 553 Viewing the List of Databases 553 Altering a Database 554 Dropping a Database 554 Creating and Managing Tablespaces 582 Defining Date Range Table Partitions 582 Defining Numeric Range Table Partitions 583 Defining List Table Partitions 584 Defining Multi-level Partitions 584 Partitioning an Existing Table 585 Limitations

502 Auditing 502 VMware Greenplum 6 Documentation VMware, Inc. 23 Viewing the Database Server Log Files 503 Encrypting Data and Database Connections 506 Encrypting gpfdist Connections 507 Encrypting Database 523 Cloning a Database 524 Creating a Database with a Different Owner 524 Viewing the List of Databases 524 Altering a Database 525 Dropping a Database 525 Creating and Managing Tablespaces 553 Defining Date Range Table Partitions 553 Defining Numeric Range Table Partitions 554 Defining List Table Partitions 554 Defining Multi-level Partitions 555 Partitioning an Existing Table 556 Limitations

Constraints 503 Dropping a Time-based Restriction 504 Auditing 504 Viewing the Database Server Log Files 505 Encrypting Data and Database Connections 508 Encrypting gpfdist Connections 508 Encrypting Database 524 Cloning a Database 525 Creating a Database with a Different Owner 525 Viewing the List of Databases 525 Altering a Database 525 Dropping a Database 526 Creating and Managing Tablespaces 552 Defining Date Range Table Partitions 553 Defining Numeric Range Table Partitions 554 Defining List Table Partitions 554 Defining Multi-level Partitions 554 Partitioning an Existing Table 555 Limitations