[GitHub] drill issue #786: DRILL-5359: Fix ClassCastException when Drill pushes down ...

Github user amansinha100 commented on the issue: https://github.com/apache/drill/pull/786 +1 --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the

[jira] [Created] (DRILL-5363) CURRENT_TIMESTAMP() documented, but not actually available in Drill

Paul Rogers created DRILL-5363: -- Summary: CURRENT_TIMESTAMP() documented, but not actually available in Drill Key: DRILL-5363 URL: https://issues.apache.org/jira/browse/DRILL-5363 Project: Apache Drill

[jira] [Created] (DRILL-5362) CURRENT_TIME() documented, but not actually available in Drill

Paul Rogers created DRILL-5362: -- Summary: CURRENT_TIME() documented, but not actually available in Drill Key: DRILL-5362 URL: https://issues.apache.org/jira/browse/DRILL-5362 Project: Apache Drill

[jira] [Created] (DRILL-5361) CURRENT_DATE() documented, but not actually available in Drill

Paul Rogers created DRILL-5361: -- Summary: CURRENT_DATE() documented, but not actually available in Drill Key: DRILL-5361 URL: https://issues.apache.org/jira/browse/DRILL-5361 Project: Apache Drill

Re: Drill date & time types encoding

I think they are using the same timezone data from IANA, For Java the timezone data can be found under jre/lib/zi, and Oracle has a timezone update tool too. For enterprise software vendors, timezone update actually is a big thing. From: Boaz Ben-Zvi

[GitHub] drill pull request #786: DRILL-5359: Fix ClassCastException when Drill pushe...

GitHub user jinfengni opened a pull request: https://github.com/apache/drill/pull/786 DRILL-5359: Fix ClassCastException when Drill pushes down filter on t… …he output of flatten operator. - Move findItemOrFlatten as a static method in DrillRelOptUtil. - Exclude

Re: Drill date & time types encoding

yes, you are right there is difference between "should" and "may". I "should" use "may" in the first place. However, I do not think the interpretation of a timestamp is entirely up to the user (Do you mean the end user of a database product?). What if the implementation of database takes a

Re: Drill date & time types encoding

Timezone calculations are not simple ( e.g., “2017-03-11 23:30:00-PST” + INTERVAL ‘3’ HOURS --> need to know about daylight savings time, etc.) Linux does have a timezone. The actual implementation is quite complex – it keeps an elaborate “database” under /usr/share/zoneinfo , (which

Re: Having some trouble locating a file referenced in the Advanced Regression tests

I already did :) On Thu, Mar 16, 2017 at 5:31 PM, Aman Sinha wrote: > I am guessing Rahul Chalapalli might have created that data file. Rahul, > can you comment ? > > -Aman > > On 3/16/17, 11:57 AM, "Jason Altekruse" wrote: > > Hey Drillers, > >

Re: Drill date & time types encoding

The difference between “should” and “may”. The interpretation of a timestamp is entirely up to the user. If I am reading a timestamp value from a database, and I know it to be in local timezone, I use the ResultSet.getTimestamp(int) method, which (per the JDBC spec) interprets the value as

Re: Issue with OBIEE 12c

You might want to refer to this. https://www.rittmanmead.com/blog/2016/08/using-apache-drill-with-obiee-12c/ On 3/16/17, 8:43 AM, "Di Camillo, Fabrizio" wrote: Hi guru, we are using Apache Drill (1.9) driver for OBIEE 12c (64 bit). Some

Re: Having some trouble locating a file referenced in the Advanced Regression tests

I am guessing Rahul Chalapalli might have created that data file. Rahul, can you comment ? -Aman On 3/16/17, 11:57 AM, "Jason Altekruse" wrote: Hey Drillers, I am working to set up a test environment to run the Advanced Regression suites. I have

Re: Drill date & time types encoding

On Thu, Mar 16, 2017 at 4:41 PM, Julian Hyde wrote: > >> On Mar 16, 2017, at 4:25 PM, Jinfeng Ni wrote: >> >> Time/Timestamp without t/z should be interpreted as local time. > > > No. > > If I am in pacific time and I have a TIMESTAMP value “1970-01-01

Re: Drill date & time types encoding

Thanks all for the explanations! Did a bit of poking around. See DRILL-5360. For the Timestamp type: * Literals are claimed to be in UTC (have not yet tested) * Value vectors store Timestamps in server local time * Drill clients get the Timestamp in server local time * JDBC clients try to

Re: Drill date & time types encoding

> On Mar 16, 2017, at 4:25 PM, Jinfeng Ni wrote: > > Time/Timestamp without t/z should be interpreted as local time. No. If I am in pacific time and I have a TIMESTAMP value “1970-01-01 12:00:00” and I send it to you in central european time you receive a TIMESTAMP value

Re: Drill date & time types encoding

My understanding is TIME/TIMESTAMP in Drill is TIME/TIMESTAMP without timezone. TimeStampTZ is for TIMESTAMP with timezone, which Drill probably does not fully support. SQL standards has DATE, TIME WITHOUT TIME ZONE, TIMESTAMP WITHOUT TIME ZONE, TIME WITH TIME ZONE, or TIMESTAMP WITH TIME ZONE.

Re: Having some trouble locating a file referenced in the Advanced Regression tests

Hmmsomehow that entry is missing from the pom file. I went back in the git history and found the below link[1]. I was able to download it. Let me know if you have any problems. [1] http://apache-drill.s3.amazonaws.com/files/widestrings-10rows.tgz - Rahul On Thu, Mar 16, 2017 at 11:57

[jira] [Created] (DRILL-5360) Timestamp type documented as UTC, implemented as local time

Paul Rogers created DRILL-5360: -- Summary: Timestamp type documented as UTC, implemented as local time Key: DRILL-5360 URL: https://issues.apache.org/jira/browse/DRILL-5360 Project: Apache Drill

[jira] [Created] (DRILL-5359) ClassCastException when push down filter on the output of flatten into parquet scan

Jinfeng Ni created DRILL-5359: - Summary: ClassCastException when push down filter on the output of flatten into parquet scan Key: DRILL-5359 URL: https://issues.apache.org/jira/browse/DRILL-5359 Project:

[GitHub] drill pull request #781: DRILL-5351: Minimize bounds checking in var len vec...

Github user paul-rogers commented on a diff in the pull request: https://github.com/apache/drill/pull/781#discussion_r106491214 --- Diff: exec/vector/src/main/codegen/templates/VariableLengthVectors.java --- @@ -502,11 +502,15 @@ public void setSafe(int index, byte[] bytes) {

Issue with OBIEE 12c

Hi guru, we are using Apache Drill (1.9) driver for OBIEE 12c (64 bit). Some queries failed with this error: [nQSError: 16011] ODBC error occurred while executing SQLExtendedFetch to retrieve the results of a SQL This is an errore message from OBIEE but we cannot find any details from apache

[GitHub] drill issue #520: DRILL-3510: Add ANSI_QUOTES option so that Drill's SQL Par...

Github user laurentgo commented on the issue: https://github.com/apache/drill/pull/520 good catch for javax.validation, I don't think I ever tested the driver in a context where the annotations were not present in the classpath --- If your project is set up for it, you can reply to

[GitHub] drill pull request #520: DRILL-3510: Add ANSI_QUOTES option so that Drill's ...

Github user laurentgo commented on a diff in the pull request: https://github.com/apache/drill/pull/520#discussion_r106480140 --- Diff: exec/jdbc-all/pom.xml --- @@ -403,7 +402,6 @@ **/*.SF **/*.RSA **/*.DSA -

[GitHub] drill pull request #520: DRILL-3510: Add ANSI_QUOTES option so that Drill's ...

Github user laurentgo commented on a diff in the pull request: https://github.com/apache/drill/pull/520#discussion_r106479965 --- Diff: exec/jdbc/pom.xml --- @@ -100,6 +100,11 @@ xalan xalan + --- End diff -- Might not be needed.

Re: A tutorial on how to write a custom storage plugin

Sorry, somehow Github “flagged” my account and shut down public access. Should be back to normal now. - Paul > On Mar 16, 2017, at 4:10 AM, Muhammad Gelbana wrote: > > That's very helpful Paul ! But I can't access the wiki page you referenced. > May be it's set to private

Re: [ANNOUNCE] Apache Drill 1.10.0 Released

Thanks Abhishek for the reminder. I just pushed 1.10.0 branch to Github. On Thu, Mar 16, 2017 at 9:26 AM, Abhishek Girish wrote: > Congratulations all! > > @Jinfeng, I don't see a 1.10.0 branch on GitHub yet. Is > branch creation still pending? > >

Re: [ANNOUNCE] Apache Drill 1.10.0 Released

Congratulations all! @Jinfeng, I don't see a 1.10.0 branch on GitHub yet. Is branch creation still pending? -Abhishek From: Jinfeng Ni Sent: Thursday, March 16, 2017 8:40:07 AM To: dev; user Subject: [ANNOUNCE] Apache

Re: Reg: Column name is not passed to RDBMS

Can you please first check the EXPLAIN PLAN output for your query? The first step is to figure out whether it's planner issue, or execution issue. On Thu, Mar 16, 2017 at 7:39 AM, Nishith Kumar Nayak wrote: > Hi, > > While trying to run SQL query for RDBMS source like

[GitHub] drill issue #520: DRILL-3510: Add ANSI_QUOTES option so that Drill's SQL Par...

Github user vdiravka commented on the issue: https://github.com/apache/drill/pull/520 @laurentgo The branch is updated to master drill-1.11.0-SNAPSHOT. Quoting_identifiers metadata is left without handling direct session changes. Also I found one issue, when tried to

[GitHub] drill pull request #520: DRILL-3510: Add ANSI_QUOTES option so that Drill's ...

Github user vdiravka commented on a diff in the pull request: https://github.com/apache/drill/pull/520#discussion_r106453245 --- Diff: exec/jdbc/src/main/java/org/apache/drill/jdbc/impl/DrillDatabaseMetaDataImpl.java --- @@ -184,6 +184,17 @@ private ServerMeta getServerMeta()

[ANNOUNCE] Apache Drill 1.10.0 Released

On behalf of the Apache Drill community, I am happy to announce the release of Apache Drill 1.10.0. For information about Apache Drill, and to get involved, visit the project website [1]. This release introduces new features and enhancements, including CREATE TEMPORARY TABLE AS command, Kerberos

questions about FPGA plan to Drill

HI all: I notices that @Eric Fukuda ever have done some work to use FPGA to power Drill.It seems so impressive ! I want to know some recently news about that.Does anyone know about that? I have no contact to him. Best Regards

Re: A tutorial on how to write a custom storage plugin

That's very helpful Paul ! But I can't access the wiki page you referenced. May be it's set to private ? *-* *Muhammad Gelbana* http://www.linkedin.com/in/mgelbana On Thu, Mar 16, 2017 at 1:50 AM, Paul Rogers wrote: > Hi Muhammad, > > I know of no

[jira] [Created] (DRILL-5358) Error if Parquet file changes during query

Tobias created DRILL-5358: - Summary: Error if Parquet file changes during query Key: DRILL-5358 URL: https://issues.apache.org/jira/browse/DRILL-5358 Project: Apache Drill Issue Type: Bug