What is HiveQL

hive>create schema if not exists test;

hive>create external table if not exists test.test_data (row1 int, row2 int, row3 decimal(10,3), row4 int) row format delimited fields terminated by ',' stored as textfile location 'hdfs://172.18.1.1:9000/user/hadoop/test/';

hive>select * from test.test_data where row3 > 2.499;
SELECT * FROM test.test_data WHERE row3 > 2.499;

References