Hitachi Vantara Pentaho Community Wiki
Child pages
  • PA_CR_PA-3.9.X_presto-0.100

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Feature

Status

Notes

Concurrency and Thread Safety


 

Degenerate Schemas

 

Star Schemas


 

Snowflake Schemas


 

Filters


 

Top Count


setMaxRows() is not implemented correctly in the JDBC driver.

Aggregation Tables


Implicit aggregation tables are not recognized by Mondrian. The JDBC driver does not implement java.sql.DatabaseMetaData.getTables

Null Values & Keys


 

Inline Tables


 

Distinct Count


Not all forms of distinct counts are supported, although the minimum support it offers is sufficient for Mondrian.

Grouping Sets


Grouping sets are not supported.

Metadata and data types

Image Added

The type of certain columns is not reported properly by the JDBC driver.

Failures

X

Symptom

X

Code Block
Ca

...

Test

Result

org.pentaho.mondrian.tck.AggregationTablesRecognitionTest.testAggregationRecognition


Code Block
java.lang.AssertionError: Expected sql was not executed:
select
    sum(agg_c_10_sales_fact_1997.customer_count) m0
from
    agg_c_10_sales_fact_1997 agg_c_10_sales_fact_1997
	at org.junit.Assert.fail(Assert.java:88)
	at org.junit.Assert.assertTrue(Assert.java:41)
	at org.pentaho.mondrian.tck.MondrianExpectation.verifySqls(MondrianExpectation.java:119)
	at org.pentaho.mondrian.tck.MondrianExpectation.verify(MondrianExpectation.java:91)
	at org.pentaho.mondrian.tck.MondrianContext.verify(MondrianContext.java:167)
	at org.pentaho.mondrian.tck.AggregationTablesRecognitionTest$2.run(AggregationTablesRecognitionTest.java:93)
	at org.pentaho.mondrian.tck.PropertyContext.execute(PropertyContext.java:40)
	at org.pentaho.mondrian.tck.AggregationTablesRecognitionTest.testAggregationRecognition(AggregationTablesRecognitionTest.java:77)

Metadata and data types

Symptom

The driver's metadata identifies integer columns as BigInteger objects. This can be worked around by crafting the mondrian schema correctly and forcing the types to those expected.

Failed tests

Test

Result

org.pentaho.mondrian.tck.JoinTest.testTwoWayJoin89


Code Block
java.lang.AssertionError: Wrong meta type for column warehouse_id, expected meta type 4 but actual meta type was -5 expected:<4> but was:<-5>
	at org.junit.Assert.fail(Assert.java:88)
	at org.junit.Assert.failNotEquals(Assert.java:743)
	at org.junit.Assert.assertEquals(Assert.java:118)
	at org.junit.Assert.assertEquals(Assert.java:555)
	at org.pentaho.mondrian.tck.ResultSetValidator.validateMetaType(ResultSetValidator.java:188)
	at org.pentaho.mondrian.tck.ResultSetValidator.validateRows(ResultSetValidator.java:124)
	at org.pentaho.mondrian.tck.SqlExpectation.verify(SqlExpectation.java:74)
	at org.pentaho.mondrian.tck.SqlContext.verify(SqlContext.java:134)
	at org.pentaho.mondrian.tck.JoinTest.testTwoWayJoin89(JoinTest.java:144)
  • There are numerous other failed tests due to data types.

Grouping sets

Symptom

Queries which use grouping sets are not supported. This is a optimization feature supported by some more advanced databases. It allows to batch cell requests and improve the overall performance.

Failed tests

Test

Result

org.pentaho.mondrian.tck.GroupingSetTest.testEmptyEntry

Grouping set queries are not supported.

Code Block
select
    customer.gender as gender, sum(sales_fact_1997.store_cost) as sum_cost
from
    time_by_day, sales_fact_1997, customer
where
    (sales_fact_1997.time_id = time_by_day.time_id and time_by_day.the_year = 1997
    and sales_fact_1997.customer_id = customer.customer_id)
group by grouping sets
    ((customer.gender),())

org.pentaho.mondrian.tck.GroupingSetTest.testPlainEntry

Grouping set queries are not supported.

Code Block
select
    customer.gender as gender, sum(sales_fact_1997.store_cost) as sum_cost
from
    time_by_day, sales_fact_1997, customer
where
    (sales_fact_1997.time_id = time_by_day.time_id and time_by_day.the_year = 1997
    and sales_fact_1997.customer_id = customer.customer_id)
group by grouping sets
    ((customer.gender))

org.pentaho.mondrian.tck.GroupingSetTest.testComplexEntry

Grouping set queries are not supported.

Code Block
select
    time_by_day.the_year as the_year, customer.gender as gender, sum(sales_fact_1997.store_cost) as sum_cost
from
    time_by_day, sales_fact_1997, customer
where
    (sales_fact_1997.time_id = time_by_day.time_id and time_by_day.the_year = 1997
    and sales_fact_1997.customer_id = customer.customer_id)
group by grouping sets
    ((time_by_day.the_year, customer.gender))

org.pentaho.mondrian.tck.GroupingSetTest.testMultipleEntries

Grouping set queries are not supported.

Code Block
select
    time_by_day.the_year as the_year, customer.gender as gender, sum(sales_fact_1997.store_cost) as sum_cost
from
    time_by_day, sales_fact_1997, customer
where
    (sales_fact_1997.time_id = time_by_day.time_id and time_by_day.the_year = 1997
    and sales_fact_1997.customer_id = customer.customer_id)
group by grouping sets
    ((time_by_day.the_year, customer.gender), (time_by_day.the_year),())