Package mondrian.spi.impl

Class VectorwiseDialect

  • All Implemented Interfaces:
    Dialect
    public class VectorwiseDialect
extends IngresDialect
    Implementation of Dialect for the Vertica database.
    Since:
    Sept 11, 2009
    Author:
    LBoudreau

    • Constructor Detail

      • VectorwiseDialect

        public VectorwiseDialect​(Connection connection)
                  throws SQLException
        Creates a VectorwiseDialect.
        Parameters:
        connection - Connection
        Throws:
        SQLException

    • Method Detail

      • requiresHavingAlias

        public boolean requiresHavingAlias()
        Description copied from interface: Dialect
        Returns true if this Dialect can include expressions in the HAVING clause only by adding an expression to the SELECT clause and using its alias.

        For example, in such a dialect,

        SELECT CONCAT(x) as foo FROM t HAVING CONCAT(x) LIKE "%"
        would be illegal, but
        SELECT CONCAT(x) as foo FROM t HAVING foo LIKE "%"
        would be legal.

        MySQL is an example of such dialects.

        Specified by:
        requiresHavingAlias in interface Dialect
        Overrides:
        requiresHavingAlias in class JdbcDialectImpl
        Returns:
        Whether this Dialect can include expressions in the HAVING clause only by adding an expression to the SELECT clause and using its alias

      • requiresUnionOrderByOrdinal

        public boolean requiresUnionOrderByOrdinal()
        Description copied from interface: Dialect
        Returns true if this dialect allows only integers in the ORDER BY clause of a UNION (or other set operation) query.

        For example, SELECT x, y + z FROM t
        UNION ALL
        SELECT x, y + z FROM t
        ORDER BY 1, 2         is allowed but SELECT x, y, z FROM t
        UNION ALL
        SELECT x, y, z FROM t
        ORDER BY x         is not.

        Teradata is an example of a dialect with this restriction.

        Specified by:
        requiresUnionOrderByOrdinal in interface Dialect
        Overrides:
        requiresUnionOrderByOrdinal in class JdbcDialectImpl
        Returns:
        whether this dialect allows only integers in the ORDER BY clause of a UNION (or other set operation) query