Hypertable sql
来源:互联网 发布:剑桥国际英语 知乎 编辑:程序博客网 时间:2024/06/05 10:05
First, create a new namespace called “Test”:
CREATE NAMESPACE Test;
and make it the current namespace:
USE Test;
Now, let’s create a new table within the current namespace:
CREATE TABLE fruits (color, energy, protein, vitamins);
and insert some data:
INSERT INTO fruits VALUES ("apple", "color", "red"),
("apple", "energy", "207KJ"),
("apple", "protein", "0.4g"),
("apple", "vitamins:C", "15mg"),
("apple", "vitamins:B1", "0.02mg");
INSERT INTO fruits VALUES ("banana", "color", "yellow"),
("banana", "energy", "375KJ"),
("banana", "protein", "1.2g"),
("banana", "vitamins:C", "10mg"),
("banana", "vitamins:B1", "0.04mg");
Finally, issue some queries, for example:
SELECT CELLS * FROM fruits;
SELECT CELLS * FROM fruits WHERE ROW=”banana”;
SELECT CELLS vitamins FROM fruits WHERE ROW=”apple”;
SELECT CELLS vitamins:B1 FROM fruits;
0 0
- Hypertable sql
- Hypertable
- Hypertable
- hypertable原理
- hypertable安装
- Hypertable简介
- Hypertable - 概述
- Hypertable - 架构
- HyperTable介绍
- hypertable bug
- hypertable介绍
- Hypertable源码解读之Hypertable.lib目录
- Hypertable源码解读之Hypertable.RangeServer目录
- Hypertable源码解读之Hypertable.lib目录
- 集成Hadoop和Hypertable
- 安装了hypertable
- hypertable学习中段
- KFS,Hypertable,Hadoop
- js正则关键字详解
- Android应用在不同版本间兼容性处理
- MySQL数据类型和常用字段属性总结
- java项目打包成exe可执行文件
- d3.js——绘制打包图
- Hypertable sql
- 蜜罐对企业安全的作用
- 那些NB到不可思议的网站
- 《Thrift: The Missing Guide》笔记
- 深入浅出RxJava(一:基础篇)
- oracle删除用户
- linux下的source命令
- orcal 统计表中不同类型的数量
- 字符串基础题2道-NYOJ-113(字符串替换)-519(密码发生器)