マイナビニュース

ゼロから始めるクラウド型DWH「Azure SQL Data Warehouse」

今回も以下のように、前回と同じSQLのチューニングを行います。 select l_orderkey, sum(l_extendedprice * (1 - l_discount)) as revenue, o_orderdate, o_shippriority from customer, orders, lineitem where c_mktsegment = 'BUILDING' and c ...
GitHub

placement-rules-in-sql.md

Placement Rules in SQL is a feature that enables you to specify where data is stored in a TiKV cluster using SQL interfaces. Using this feature, tables and partitions are scheduled to specific regions ...
GitHub

usp_switch_partition.sql

-- WARNING: This is a proof-of-concept. Do not use this code in any production environment without extensive testing and/or re-writing the code. -- Description -- Target table with the same structure ...