[jira] [Commented] (DRILL-6134) Many Drill queries fail with type mismatch when using JDBC Driver from Simba
[
https://issues.apache.org/jira/browse/DRILL-6134?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16392073#comment-16392073
]
Tom Barber commented on DRILL-6134:
---
Yeah i see the same with the stock JDBC driver and Mondrian over CSV files.
> Many Drill queries fail with type mismatch when using JDBC Driver from Simba
>
>
> Key: DRILL-6134
> URL: https://issues.apache.org/jira/browse/DRILL-6134
> Project: Apache Drill
> Issue Type: Bug
>Affects Versions: 1.13.0
>Reporter: Robert Hou
>Assignee: Pritesh Maker
>Priority: Major
>
> Here is an example:
> Query:
> /root/drillAutomation/framework-master/framework/resources/Functional/limit0/union/data/union_51.q
> {noformat}
> (SELECT c2 FROM `union_01_v` ORDER BY c5 DESC nulls first) UNION (SELECT c2
> FROM `union_02_v` ORDER BY c5 ASC nulls first){noformat}
> This is the error:
> {noformat}
> Exception:
> java.sql.SQLException: [JDBC Driver]The field c2(BIGINT:OPTIONAL)
> [$bits$(UINT1:REQUIRED), $values$(BIGINT:OPTIONAL)] doesn't match the
> provided metadata major_type {
> minor_type: BIGINT
> mode: OPTIONAL
> }
> name_part {
> name: "$values$"
> }
> value_count: 18
> buffer_length: 144
> .
> at
> com.google.common.base.Preconditions.checkArgument(Preconditions.java:145)
> at org.apache.drill.exec.vector.BigIntVector.load(BigIntVector.java:287)
> at
> org.apache.drill.exec.vector.NullableBigIntVector.load(NullableBigIntVector.java:274)
> at
> org.apache.drill.exec.record.RecordBatchLoader.load(RecordBatchLoader.java:131)
> at
> com.mapr.drill.drill.dataengine.DRJDBCResultSet.doLoadRecordBatchData(Unknown
> Source)
> at com.mapr.drill.drill.dataengine.DRJDBCResultSet.hasMoreRows(Unknown
> Source)
> at
> com.mapr.drill.drill.dataengine.DRJDBCResultSet.doMoveToNextRow(Unknown
> Source)
> at com.mapr.drill.jdbc.common.CommonResultSet.moveToNextRow(Unknown
> Source)
> at com.mapr.drill.jdbc.common.SForwardResultSet.next(Unknown Source)
> at
> org.apache.drill.test.framework.DrillTestJdbc.executeQuery(DrillTestJdbc.java:255)
> at
> org.apache.drill.test.framework.DrillTestJdbc.run(DrillTestJdbc.java:115)
> at
> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:473)
> at java.util.concurrent.FutureTask.run(FutureTask.java:262)
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
> at java.lang.Thread.run(Thread.java:748)
> Caused by: java.lang.IllegalArgumentException: The field c2(BIGINT:OPTIONAL)
> [$bits$(UINT1:REQUIRED), $values$(BIGINT:OPTIONAL)] doesn't match the
> provided metadata major_type {
> minor_type: BIGINT
> mode: OPTIONAL
> }
> name_part {
> name: "$values$"
> }
> value_count: 18
> buffer_length: 144
> .
> ... 16 more{noformat}
>
> The commit that causes these errors to occur is:
> {noformat}
> https://issues.apache.org/jira/browse/DRILL-6049
> Rollup of hygiene changes from "batch size" project
> commit ID e791ed62b1c91c39676c4adef438c689fd84fd4b{noformat}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
[jira] [Commented] (DRILL-3992) Unable to query Oracle DB using JDBC Storage Plug-In
[
https://issues.apache.org/jira/browse/DRILL-3992?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14980175#comment-14980175
]
Tom Barber commented on DRILL-3992:
---
Checked and verified in Exasol, works a treat, thanks Jacques!
> Unable to query Oracle DB using JDBC Storage Plug-In
>
>
> Key: DRILL-3992
> URL: https://issues.apache.org/jira/browse/DRILL-3992
> Project: Apache Drill
> Issue Type: Bug
> Components: Query Planning & Optimization
>Affects Versions: 1.2.0
> Environment: Windows 7 Enterprise 64-bit, Oracle 10g, Teradata 15.00
>Reporter: Eric Roma
>Priority: Minor
> Labels: newbie
> Fix For: 1.2.0
>
>
> *See External Issue URL for Stack Overflow Post*
> *Appears to be similar issue at
> http://stackoverflow.com/questions/33370438/apache-drill-1-2-and-sql-server-jdbc*
> Using Apache Drill v1.2 and Oracle Database 10g Enterprise Edition Release
> 10.2.0.4.0 - 64bit in embedded mode.
> I'm curious if anyone has had any success connecting Apache Drill to an
> Oracle DB. I've updated the drill-override.conf with the following
> configurations (per documents):
> drill.exec: {
> cluster-id: "drillbits1",
> zk.connect: "localhost:2181",
> drill.exec.sys.store.provider.local.path = "/mypath"
> }
> and placed the ojdbc6.jar in \apache-drill-1.2.0\jars\3rdparty. I can
> successfully create the storage plug-in:
> {
> "type": "jdbc",
> "driver": "oracle.jdbc.driver.OracleDriver",
> "url": "jdbc:oracle:thin:@::",
> "username": "USERNAME",
> "password": "PASSWORD",
> "enabled": true
> }
> but when I issue a query such as:
> select * from ..`dual`;
> I get the following error:
> Query Failed: An Error Occurred
> org.apache.drill.common.exceptions.UserRemoteException: VALIDATION ERROR:
> From line 1, column 15 to line 1, column 20: Table
> '..dual' not found [Error Id:
> 57a4153c-6378-4026-b90c-9bb727e131ae on :].
> I've tried to query other schema/tables and get a similar result. I've also
> tried connecting to Teradata and get the same error.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Commented] (DRILL-1851) Need some samples for RANK(), ROW_NUMBER(), SubQuery in SELECTStatement - Apache Drill
[ https://issues.apache.org/jira/browse/DRILL-1851?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14978282#comment-14978282 ] Tom Barber commented on DRILL-1851: --- Hello folks, ROW_NUMBER works for me in 1.2 so I don't know how much of this ticket remains open: select ROW_NUMBER() OVER (ORDER BY columns[0]), columns[0] from dfs.`/home/bugg/tmp/hads/` limit 10; Just thought I'd let those watching know! Tom > Need some samples for RANK(), ROW_NUMBER(), SubQuery in SELECTStatement - > Apache Drill > -- > > Key: DRILL-1851 > URL: https://issues.apache.org/jira/browse/DRILL-1851 > Project: Apache Drill > Issue Type: New Feature > Components: Functions - Drill >Affects Versions: 0.6.0 > Environment: Drill SQL >Reporter: Chandru >Priority: Critical > Fix For: Future > > Attachments: Issue_Hugefiles-Drill.jpg > > Original Estimate: 2h > Remaining Estimate: 2h > > Provide some sample queries for the below scenarios, > 1.RANK( ) function > rank() over (ORDER BY columns[0] DESC) as rowcount > 2. ROW_NUMBER( ) function > row_number() over (PARTITION BY columns[0] ORDER BY columns[1] DESC) as > rowcount > 3. SubQuery in Select Statement. > SELECT paccnt.R_NAME, > CAST((SELECT N_NATIONKEY FROM > dfs.`/home/user/drill/drill-0.6.0/sample-data/nation.parquet`) AS CHAR) AS > NUMB > from dfs.`/home/user/drill/drill-0.6.0/sample-data/region.parquet` as paccnt; -- This message was sent by Atlassian JIRA (v6.3.4#6332)
