Daily Archives: July 22, 2015

HBase Functions Cheat Sheet 3

This entry was posted in HBase on by

HBase Functions Cheat Sheet SHELL [cloudera@quickstart ~]$ hbase shell LIST hbase(main):003:0> list SCAN Scanner specifications may include one or more of: TIMERANGE, FILTER, LIMIT, STARTROW, STOPROW, TIMESTAMP, MAXLENGTH, or COLUMNS, CACHE. If no columns are specified, all columns will be scanned. To scan all members of a column family, leave the qualifier empty as in ‘col_family:’ hbase(main):012:0> scan ‘myFirstTable’ SCAN WITH FILTER hbase(main):079:0> scan ‘sales_fact’, { FILTER => “KeyOnlyFilter()”} –> […]

Good SQL Queries Collection

This entry was posted in SQL Interview Questions on by

Good SQL Queries Collection /* CREATE TABLE FOR DEPARTMENT */ CREATE TABLE DEPARTMENT ( “DEPT_ID” NUMBER, “DEPT_NAME” VARCHAR2(30), PRIMARY KEY (“DEPT_ID”) ) /* CREATE TABLE FOR EMP */ CREATE TABLE EMPLOYEE ( “EMP_ID” NUMBER, “MGR_ID” NUMBER, “DEPT_ID” NUMBER, “EMP_NAME” VARCHAR2(30), “SAL” NUMBER, “DOJ” DATE, PRIMARY KEY (“EMP_ID”) ENABLE, FOREIGN KEY (“MGR_ID”) REFERENCES EMPLOYEE (“EMP_ID”) ENABLE, FOREIGN KEY (“DEPT_ID”) REFERENCES DEPARTMENT (“DEPT_ID”) ENABLE ) /* INSERT STATEMENT FOR DEPARTMENT */ INSERT […]

Review Comments
default image

I have attended Siva’s Spark and Scala training. He is good in presentation skills and explaining technical concepts easily to everyone in the group. He is having excellent real time experience and provided enough use cases to understand each concepts. Duration of the course and time management is awesome. Happy that I found a right person on time to learn Spark. Thanks Siva!!!

Dharmeswaran ETL / Hadoop Developer Spark Nov 2016 September 21, 2017

.