Select individual properties from an object

Select individual properties from the data object. Object names are not case-sensitive. Property names are case-sensitive.

In the example that is mentioned earlier, “property1” and “property2” are property names. The case that is used in the query must match the case of the property names in the Data Catalog’s metadata definition.

The result of a query without a WHERE lastModified condition are the "rows" of data in a single payload object. The rows correspond to the tuples in the latest object loaded into the Data Lake. In BIRST the properties are returned in alphabetical order, regardless of the order in which they are specified in the select statement.

Syntax

SELECT property1, property2 from object