ARRAY[expr1, expr2, ...] Constructs a SQL ARRAY literal from the expression arguments, using the type of the first argument as the output array type. ARRAY_LENGTH(arr) Returns length of the array ...

The Java tutorial has an example showing JDBC usage of Array of String. A workaround for the array limitation in ES-SQL exists by wrapping the primitive values in an object containing just that value.

Abstract: The success of SQL, NoSQL, and NewSQL databases is a reflection of their ability to provide significant functionality and performance benefits for specific domains, such as financial ...