SQL Reference

The following documents describe important aspects of the Okera SQL syntax that can be used to define access control views in Okera. For additional information, please refer to the Supported SQL documentation.

Overview

Okera follows the HiveQL standard as prominent in the Hadoop ecosystem. This makes it easy for Hadoop administrators and Hive developers to become familiar with the Okera features. Since the syntax is closely related to standard SQL, even regular DBAs and developers will find it relatively easy to adopt Okera's functionality. While related to HiveQL, there are a few exceptions on how Okera SQL can be used. These differences are pointed out in the various sub-sections.

The documents below will first introduce the basic building blocks for Okera SQL and then explain how they are combined to express more complex logic. Finally, there is a list of the built-in functions that can be used to implement context dependent expressions.

Subsections:

• Data Types

• Basic Expressions and Operators

• Predicates

• Builtin Functions