Dynamic Columns
来源:互联网 发布:php 返回上个页面 编辑:程序博客网 时间:2024/06/04 16:32
Dynamic Columns
specifying columns dynamically is now supported by allowing column definitions to included in parenthesis after the table in theFROM clause on a SELECT statement
通过允许列定义在SELECT语句的FROM子句后的括号中包含在括号中,可以动态地指定列
For example:
SELECT eventTime, lastGCTime, usedMemory, maxMemory
FROM EventLog(lastGCTime TIME, usedMemory BIGINT, maxMemory BIGINT)
WHERE eventType = 'OOM' AND lastGCTime < eventTime - 1
Where you may have defined only a subset of your event columns at create time, since each event type may have different properties:
CREATE TABLE EventLog (
eventId BIGINT NOT NULL,
eventTime TIME NOT NULL,
eventType CHAR(3)
CONSTRAINT pk PRIMARY KEY (eventId, eventTime))
To upsert a row with dynamic columns:
UPSERT INTO EventLog (eventId, eventTime, eventType, lastGCTime TIME, usedMemory BIGINT, maxMemory BIGINT) VALUES(1, CURRENT_TIME(), ‘abc’, CURRENT_TIME(), 512, 1024);
- Dynamic Columns
- WPF Dynamic Columns Binding & EditingTemplate by MVVM.
- Dynamic Group-By Columns for Jasper Report
- dynamic
- @dynamic
- Dynamic
- @dynamic
- dynamic
- dynamic
- dynamic
- @dynamic
- @dynamic
- POJ_1617_Crypto Columns
- Crypto Columns
- Removing Columns
- Removing Columns
- jqgrid columns
- Removing Columns
- CTEX的一些常用技巧
- 如何用ps制作苹果
- 给定一个数判断是否为2的幂
- linux定时任务
- mapreduce实现writable接口自定义输出格式
- Dynamic Columns
- 解决windows adb 脆弱的问题
- OpenCV手写数字字符识别(基于k近邻算法)
- redis本地连接远程报错
- 数据结构之二叉树
- Flask使用总结
- 浏览器HTTP缓存机制
- 进入IT行业这么久,你真的了解整个软件开发的流程?看完就懂了!
- Android 抗锯齿的两种方式