This topic outlines the Hive DQL commands and syntax that the Dataphin compute engine supports when operating in Hadoop mode.
TABLESAMPLE
Data sampling methods.
Sample from bucketed table
TABLESAMPLE (BUCKET x OUT OF y [ON colname])Block-based sampling
TABLESAMPLE (n PERCENT)For more information, see the referenced document.
QUALIFY
Note
Note: Support for this feature varies across distributions.
SELECT <window_function() OVER()> AS alias_name FROM tbl QUALIFY alias_name <expression>