SQL in general

The general syntax of the HIVE 2.

SELECT

The general syntax of the HIVE 2 SELECT command is the following:

SELECT [ALL | DISTINCT] select_expr, select_expr, ...
  FROM my_table
  [WHERE where_condition]
  [GROUP BY col_list]
  [ORDER BY col_list]
  [LIMIT rows]

ORDER BY

Indexima adds an additional feature to the ORDER BY with ORDER BY columns NULLS FIRST / LAST.

When NULLS FIRST, all NULL values will be listed on top of the query's result.

When NULLS LAST, all NULL values will be listed at the bottom of the query's result.

The default NULL sorting order for ASC order is NULLS FIRST, while the default NULL sorting order for DESC order is NULLS LAST.

DATE_FORMAT

String DATE_FORMAT(DATE data, string format).

Returns a formatted element of the date:

• DATE_FORMAT(‘2008-12-20 12:13:14’, ‘u’) returns the day number of the week => 6 = Saturday
• DATE_FORMAT(‘2008-12-20’, ‘y’) returns the year => "2018"
• DATE_FORMAT(1463313304, ‘m’)“) returns minutes => "28".

Here the DATE is represented by a DOUBLE and corresponds to the date "Jan 17, 1970 11:28:33 PM".

Formats supported by Indexima are listed here: