Skip to content

Instantly share code, notes, and snippets.

@sankars

sankars/hbase_phoenix.sql

Created August 21, 2013 14:57
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save sankars/6295573 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save sankars/6295573 to your computer and use it in GitHub Desktop.
Download ZIP
Hbase Phoenix queries
Raw
hbase_phoenix.sql
CREATE TABLE "1004_ALERT_TYPE"
(
NAME varchar(100) primary key,
d.atd varchar(100),
d.atn varchar(10)
)
select * from "1004_ALERT_TYPE" limit 100
upsert into "1002_DEVICE_MASTER" select NAME,'1' from "1002_DEVICE_MASTER" where NAME < '2/100006'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment