Re: question about views

2018-04-30 Thread Ted Dunning
I will see what I can do to set up a test. On Mon, Apr 30, 2018, 08:10 Vitalii Diravka wrote: > Ted, > > The rules are enabled and DRILL-3855 [1] is resolved. > Please try your queries with latest Drill master version. > > [1]

[HANGOUT] Topics for 05/01/2018

2018-04-30 Thread Gautam Parai
Hi all, We will have a Drill hangout tomorrow (Tuesday May 1) at 10 AM Pacific Time. Please suggest topics by replying to this thread or bring them up during the hangout. Hangout link: https://plus.google.com/hangouts/_/event/ci4rdiju8bv04a64efj5fedd0lc Thanks, Gautam

Re: question about views

2018-04-30 Thread Vitalii Diravka
Ted, The rules are enabled and DRILL-3855 [1] is resolved. Please try your queries with latest Drill master version. [1] https://issues.apache.org/jira/browse/DRILL-3855 Kind regards Vitalii On Mon, Apr 30, 2018 at 4:31 PM Nicolas Paris wrote: > Hi > > This looks an

Re: question about views

2018-04-30 Thread Nicolas Paris
Hi This looks an interesting design. Am I correct such view would hit the RDBMS for every query ? However such view would hit the parquet file only when the timestamp predicate would match a partition ? Any news on a recent test to confirm the design ? Thanks 2018-03-20 6:49 GMT+01:00 Ted

Re: Exception While Querying Decimal Fields in Apache Drill

2018-04-30 Thread Vova Vysotskyi
Thanks for the stack trace, it helped to find the root cause of this problem. Decimal values in parquet table are stored using BINARY primitive type, but currently, Drill does not support decimals stored as binary. The good news is that it will be fixed in DRILL-6094. Kind regards, Volodymyr

RE: Exception While Querying Decimal Fields in Apache Drill

2018-04-30 Thread Peter Edike
Hi Here is the stacktrace on the server side error_type: SYSTEM message: "SYSTEM ERROR: ClassCastException: org.apache.drill.exec.vector.NullableDecimal28SparseVector cannot be cast to org.apache.drill.exec.vector.VariableWidthVector\n\nFragment 2:8\n\n[Error Id:

Re: Exception While Querying Decimal Fields in Apache Drill

2018-04-30 Thread Vova Vysotskyi
This part of the stack trace connected with the client side, could you please share a stack trace that corresponds to the error on the server side? Kind regards, Volodymyr Vysotskyi пн, 30 квіт. 2018 о 10:44 Peter Edike пише: > Hi, > > Stacktrace as requested

RE: Exception While Querying Decimal Fields in Apache Drill

2018-04-30 Thread Peter Edike
Hi, Stacktrace as requested java.sql.SQLException: [MapR][DrillJDBCDriver](500165) Query execution error. Details: SYSTEM ERROR: ClassCastException: org.apache.drill.exec.vector.NullableDecimal28SparseVector cannot be cast to org.apache.drill.exec.vector.VariableWidthVector Fragment 2:18