phoenix数据操作汇总

数智侠

于 2024-08-01 10:59:06 发布

阅读量267

点赞数 1

分类专栏： NoSQL Hadoop生态数据库文章标签：数据库 phoenix

本文链接：https://blog.csdn.net/taogumo/article/details/140841954

版权

Hadoop生态同时被 3 个专栏收录

57 篇文章 0 订阅

订阅专栏

NoSQL

6 篇文章 0 订阅

订阅专栏

数据库

6 篇文章 0 订阅

订阅专栏

0、启动phoenix

apache-phoenix-5.0.0部署-CSDN博客

1、创建表

create table testph (id varchar primary key,name varchar,age integer );

2、插入数据

upsert into testph(id,name,age) values('001','lisi',20);

3、查询数据

select * from testph;

4、分组综合案例

CREATE TABLE IF NOT EXISTS us_population (
   state CHAR(2) NOT NULL,
   city VARCHAR NOT NULL,
   population BIGINT
   CONSTRAINT my_pk PRIMARY KEY (state, city));


UPSERT INTO us_population VALUES('NY','New York',8143197);
UPSERT INTO us_population VALUES('CA','Los Angeles',3844829);
UPSERT INTO us_population VALUES('IL','Chicago',2842518);
UPSERT INTO us_population VALUES('TX','Houston',2016582);
UPSERT INTO us_population VALUES('PA','Philadelphia',1463281);
UPSERT INTO us_population VALUES('AZ','Phoenix',1461575);
UPSERT INTO us_population VALUES('TX','San Antonio',1256509);
UPSERT INTO us_population VALUES('CA','San Diego',1255540);
UPSERT INTO us_population VALUES('TX','Dallas',1213825);
UPSERT INTO us_population VALUES('CA','San Jose',912332);

SELECT state as "State",count(city) as "City Count",sum(population) as "Population Sum"
FROM us_population
GROUP BY state
ORDER BY sum(population) DESC;