Re: Dynamic UDFs support

2016-07-21 Thread Neeraja Rentachintala
It seems like we are reaching a conclusion here in terms of starting with a simpler implementation i.e being able to deploy UDFs dynamically without Drillbit restarts based off a jars in DFS location. Dropping functions dynamically is out of scope for version 1 of this feature (we assume

[GitHub] drill pull request #546: DRILL-4783: flatten operator should not throw excep...

2016-07-21 Thread asfgit
Github user asfgit closed the pull request at: https://github.com/apache/drill/pull/546 --- 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 feature is

[GitHub] drill pull request #546: DRILL-4783: flatten operator should not throw excep...

2016-07-21 Thread jinfengni
Github user jinfengni commented on a diff in the pull request: https://github.com/apache/drill/pull/546#discussion_r71825128 --- Diff: exec/java-exec/src/main/java/org/apache/drill/exec/physical/impl/flatten/FlattenRecordBatch.java --- @@ -267,6 +276,15 @@ private TransferPair

[GitHub] drill pull request #534: [DRILL-4743] HashJoin's not fully parallelized in q...

2016-07-21 Thread sudheeshkatkam
Github user sudheeshkatkam commented on a diff in the pull request: https://github.com/apache/drill/pull/534#discussion_r71823822 --- Diff: exec/java-exec/src/main/java/org/apache/drill/exec/server/options/TypeValidators.java --- @@ -90,6 +91,62 @@ public void

[GitHub] drill pull request #549: DRILL-4682: Allow full schema identifier in SELECT ...

2016-07-21 Thread jinfengni
Github user jinfengni commented on a diff in the pull request: https://github.com/apache/drill/pull/549#discussion_r71816190 --- Diff: exec/java-exec/src/test/java/org/apache/drill/TestExampleQueries.java --- @@ -1195,4 +1195,25 @@ public void testDateImplicitCasting() throws

[GitHub] drill pull request #534: [DRILL-4743] HashJoin's not fully parallelized in q...

2016-07-21 Thread gparai
Github user gparai commented on a diff in the pull request: https://github.com/apache/drill/pull/534#discussion_r71816185 --- Diff: exec/java-exec/src/main/java/org/apache/drill/exec/server/options/TypeValidators.java --- @@ -90,6 +91,62 @@ public void validate(OptionValue v) {

[GitHub] drill pull request #551: DRILL-4792: Include session options used for a quer...

2016-07-21 Thread sudheeshkatkam
Github user sudheeshkatkam commented on a diff in the pull request: https://github.com/apache/drill/pull/551#discussion_r71811276 --- Diff: protocol/src/main/protobuf/UserBitShared.proto --- @@ -176,12 +176,18 @@ message QueryData { optional RecordBatchDef def = 3; }

[GitHub] drill pull request #551: DRILL-4792: Include session options used for a quer...

2016-07-21 Thread sudheeshkatkam
Github user sudheeshkatkam commented on a diff in the pull request: https://github.com/apache/drill/pull/551#discussion_r71810483 --- Diff: exec/java-exec/src/main/resources/rest/profile/profile.ftl --- @@ -107,6 +107,42 @@ FOREMAN:

[GitHub] drill pull request #426: DRILL-4499: Remove 17 unused classes

2016-07-21 Thread sudheeshkatkam
Github user sudheeshkatkam commented on a diff in the pull request: https://github.com/apache/drill/pull/426#discussion_r71810206 --- Diff: exec/interpreter/src/test/java/org/apache/drill/exec/expr/TestPrune.java --- @@ -1,38 +0,0 @@

[GitHub] drill issue #502: DRILL-4573 Fixed issue with regexp_replace function

2016-07-21 Thread sudheeshkatkam
Github user sudheeshkatkam commented on the issue: https://github.com/apache/drill/pull/502 @jcmote can you please close this PR? The changes were merged as part of #512 --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as

[GitHub] drill issue #541: DRILL-4673: Implement "DROP TABLE IF EXISTS" for drill to ...

2016-07-21 Thread sudheeshkatkam
Github user sudheeshkatkam commented on the issue: https://github.com/apache/drill/pull/541 tl;dr +1, please open a ticket. Moving conversation. Vitalii said: > I checked every schema#getTable and found that every method can throw exception only if something go wrong

[GitHub] drill issue #545: DRILL-4746: Verification Failures (Decimal values) in dril...

2016-07-21 Thread parthchandra
Github user parthchandra commented on the issue: https://github.com/apache/drill/pull/545 +1 LGTM --- 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

[GitHub] drill issue #546: DRILL-4783: flatten operator should not throw exception if...

2016-07-21 Thread jinfengni
Github user jinfengni commented on the issue: https://github.com/apache/drill/pull/546 I picked the latest commit, and am running the regression. Will merge to master if everything runs fine. --- If your project is set up for it, you can reply to this email and have your reply

[GitHub] drill issue #546: DRILL-4783: flatten operator should not throw exception if...

2016-07-21 Thread jinfengni
Github user jinfengni commented on the issue: https://github.com/apache/drill/pull/546 LGTM. --- 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

Question about Apache Drill Use Case

2016-07-21 Thread Suma Cherukuri
Hi, Good Afternoon! I work as an engineer at Symantec. My team works on Multi-tenant Event Processing System. Just a high level background, our customers write data to kafka brokers though agents like logstash and we process the events and save the log data in Elastic Search and S3. Use

Re: A light-weight, versioned client API for Drill

2016-07-21 Thread Julian Hyde
Avatica has changed a lot since Drill first started using it. Now its default wire format is protobuf (driven by the need for something more compact and efficient than JSON, and also better at supporting mismatched client/server versions) and there are also a bunch of improvements relating to

[GitHub] drill issue #546: DRILL-4783: flatten operator should not throw exception if...

2016-07-21 Thread jinfengni
Github user jinfengni commented on the issue: https://github.com/apache/drill/pull/546 Thanks, @jaltekruse . I'll make the change you recommended, and squashed into Chunhui's patch. --- If your project is set up for it, you can reply to this email and have your reply appear on

[jira] [Created] (DRILL-4797) Partition by aggregate function in a window query results in IllegalStateException

2016-07-21 Thread Khurram Faraaz (JIRA)
Khurram Faraaz created DRILL-4797: - Summary: Partition by aggregate function in a window query results in IllegalStateException Key: DRILL-4797 URL: https://issues.apache.org/jira/browse/DRILL-4797

Re: Dynamic UDFs support

2016-07-21 Thread Keys Botzum
Recognize the difficulty. Not suggesting this be addressed in first version. Just suggesting some thought about how a real user will workaround. Maybe some doc and/or small changes can make this easier. Keys ___ Keys Botzum Senior Principal Technologist

[GitHub] drill issue #546: DRILL-4783: flatten operator should not throw exception if...

2016-07-21 Thread jaltekruse
Github user jaltekruse commented on the issue: https://github.com/apache/drill/pull/546 One small last comment. The method testNoResult() doesn't actually verify that they query has no results, it just ignores whatever the query returns. I would recommend instead using the

[GitHub] drill issue #546: DRILL-4783: flatten operator should not throw exception if...

2016-07-21 Thread jinfengni
Github user jinfengni commented on the issue: https://github.com/apache/drill/pull/546 +1 Overall LGTM. @jaltekruse , do you have any further comment? thx. --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as

[GitHub] drill pull request #546: DRILL-4783: flatten operator should not throw excep...

2016-07-21 Thread jinfengni
Github user jinfengni commented on a diff in the pull request: https://github.com/apache/drill/pull/546#discussion_r71760001 --- Diff: exec/java-exec/src/main/java/org/apache/drill/exec/physical/impl/flatten/FlattenRecordBatch.java --- @@ -267,10 +276,21 @@ private TransferPair

Re: Dynamic UDFs support

2016-07-21 Thread Paul Rogers
Hi All, By the way, the class loading/unloading issue, while new to us Drillers, is a well-known technology in projects such as Tomcat which loads & unloads web apps, each with their own class name space (implemented by a class loader.) To make the dynamic UDF function fully usable, we’d need

[jira] [Resolved] (DRILL-4794) Regression: Wrong result for query with disjunctive partition filters

2016-07-21 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4794?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha resolved DRILL-4794. --- Resolution: Fixed Fix Version/s: 1.8.0 Fixed in commit #: 4377670 > Regression: Wrong result

[GitHub] drill pull request #550: DRILL-4794: Fix a premature exit of the outer loop ...

2016-07-21 Thread asfgit
Github user asfgit closed the pull request at: https://github.com/apache/drill/pull/550 --- 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 feature is

Re: Dynamic UDFs support

2016-07-21 Thread Paul Rogers
Hi All, Adding a dynamic DROP would, of course, be a great addition! The reason for suggesting we skip that was to control project scope. Dynamic DROP requires a synchronization step. Here’s the scenario: * Foreman A starts a query using UDF U. * Foreman B receives a request to drop UDF U,

[GitHub] drill issue #550: DRILL-4794: Fix a premature exit of the outer loop during ...

2016-07-21 Thread jinfengni
Github user jinfengni commented on the issue: https://github.com/apache/drill/pull/550 +1 LGTM --- 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,

Re: Dynamic UDFs support

2016-07-21 Thread Zelaine Fong
Neeraja, Can you clarify your "requirements", specifically So any design that requires restarts I would think would beat the purpose. Earlier in the thread, Paul had suggested deferring dynamic DROP FUNCTION from v1 because of the complexity of class unloading. However, Keys notes that if that

Re: Dynamic UDFs support

2016-07-21 Thread Neeraja Rentachintala
The whole point of this feature is to avoid Drill cluster restarts as the name indicates 'Dynamic' UDFs. So any design that requires restarts I would think would beat the purpose. I also think this is an example of a feature we start with a simple design to serve the purpose, take feedback on how

[GitHub] drill pull request #551: DRILL-4792: Include session options used for a quer...

2016-07-21 Thread arina-ielchiieva
GitHub user arina-ielchiieva opened a pull request: https://github.com/apache/drill/pull/551 DRILL-4792: Include session options used for a query as part of the p… …rofile You can merge this pull request into a Git repository by running: $ git pull

Re: Dynamic UDFs support

2016-07-21 Thread Keys Botzum
I think there are a lot of great ideas here. My one concern is the lack of unload and thus presumably replace functionality. I'm just thinking about typical actual usage. In a typical development cycle someone writes something, tries it, learns, changes it, and tries again. Assuming I

[jira] [Created] (DRILL-4796) AssertionError - Nested sum(avg(c1)) over window

2016-07-21 Thread Khurram Faraaz (JIRA)
Khurram Faraaz created DRILL-4796: - Summary: AssertionError - Nested sum(avg(c1)) over window Key: DRILL-4796 URL: https://issues.apache.org/jira/browse/DRILL-4796 Project: Apache Drill

[jira] [Created] (DRILL-4795) Nested aggregate windowed query fails - IllegalStateException

2016-07-21 Thread Khurram Faraaz (JIRA)
Khurram Faraaz created DRILL-4795: - Summary: Nested aggregate windowed query fails - IllegalStateException Key: DRILL-4795 URL: https://issues.apache.org/jira/browse/DRILL-4795 Project: Apache Drill

[jira] [Resolved] (DRILL-4744) Fully Qualified JDBC Plugin Tables return Table not Found via Rest API

2016-07-21 Thread Roman Lozovyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4744?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Roman Lozovyk resolved DRILL-4744. -- Resolution: Fixed Fix Version/s: 1.7.0 This issue can be reproduced on drill 1.6.0, but

Re: Dynamic UDFs support

2016-07-21 Thread Paul Rogers
Always good to have options… Another is to try an eventual consistency model. The invariant here is the one that was mentioned earlier. Whenever a query is submitted with UDF U, that query either fails in planning (because U is unknown) or succeeds on all nodes (at least with respect to U.)

[GitHub] drill issue #546: DRILL-4783: flatten operator should not throw exception if...

2016-07-21 Thread chunhui-shi
Github user chunhui-shi commented on the issue: https://github.com/apache/drill/pull/546 Update based on Jinfeng's comment. Jinfeng, could you check if I addressed your concern? Thanks. --- If your project is set up for it, you can reply to this email and have your reply appear on

[GitHub] drill pull request #550: DRILL-4794: Fix a premature exit of the outer loop ...

2016-07-21 Thread amansinha100
GitHub user amansinha100 opened a pull request: https://github.com/apache/drill/pull/550 DRILL-4794: Fix a premature exit of the outer loop during pruning. You can merge this pull request into a Git repository by running: $ git pull