Re: [VOTE] Apache Drill release 1.15.0 - RC2

2018-12-27 Thread Hanumath Rao Maduri
- Downloaded tarball and also built from source from [3] - Tried on my Mac - Ran unit tests. LGTM (+1) On Thu, Dec 27, 2018 at 4:45 PM Khurram Faraaz wrote: > Downloaded binaries and deployed on a 4 node CentOS 7.5 cluster. > Executed basic SQL queries > - from sqlline > - from web UI

[jira] [Created] (DRILL-6935) Apache drill show a lot of CLOSE_WAIT states when we access https://ip address:8047

2018-12-27 Thread ken (JIRA)
ken created DRILL-6935: -- Summary: Apache drill show a lot of CLOSE_WAIT states when we access https://ip address:8047 Key: DRILL-6935 URL: https://issues.apache.org/jira/browse/DRILL-6935 Project: Apache Drill

[GitHub] kkhatua opened a new pull request #1588: DRILL-6921: Add Clear button for /options filter

2018-12-27 Thread GitBox
kkhatua opened a new pull request #1588: DRILL-6921: Add Clear button for /options filter URL: https://github.com/apache/drill/pull/1588 This commit adds the following search enhancements: 1. Addition of a clear ('x') button in the search field 2. If a filter term has been entered in

Re: [VOTE] Apache Drill release 1.15.0 - RC2

2018-12-27 Thread Khurram Faraaz
Downloaded binaries and deployed on a 4 node CentOS 7.5 cluster. Executed basic SQL queries - from sqlline - from web UI - and from POSTMAN Verified Web UI, performed sanity tests. Looks good. Here is one question related to querying the new sys.functions system table. The functio

Re: [VOTE] Apache Drill release 1.15.0 - RC2

2018-12-27 Thread Kunal Khatua
- Downloaded tarball and also built from source - Tried on CentOS 7.5 against MapR profile - Ran a couple of queries consisting of TPCH dataset in Parquet format - WebUX interactions seem clean and without any apparent issue. +1 (binding) Thanks Kunal On 12/27/2018 2:37:05 PM, Boaz Ben-Zvi wrote

Re: [VOTE] Apache Drill release 1.15.0 - RC2

2018-12-27 Thread Boaz Ben-Zvi
  -- Verified gpg signature on source and binaries.   -- Checked the checksum sha512 - matched.   -- Downloaded source to Linux VM - full build and unit tests passed.   -- On the Mac - Build and unit tests passed, except the `drill_derby_test` in the `contrib/storage-jdbc` which also fails for

Re: [VOTE] Apache Drill release 1.15.0 - RC2

2018-12-27 Thread Boaz Ben-Zvi
 Hi Karthik,     I also see a (different) failure on the Mac when running the 'contrib/storage-jdbc' test: [ERROR] Error starting the server for database 'drill_derby_test'. However this test runs cleanly on Linux, so it has to do with my Mac environment. The same failures show on the old

Re: [VOTE] Apache Drill release 1.15.0 - RC2

2018-12-27 Thread Karthikeyan Manivannan
Hi, I am seeing a connection failure in a drill-jdbc-storage test on my Mac with 1.15 rc2 . Is this because of some config issue on my Mac? "[DEBUG] Configuring mojo org.codehaus.mojo:sql-maven-plugin:1.5:execute from plugin realm ClassRealm[plugin>org.codehaus.mojo:sql-maven-plugin:1.5, parent:

[GitHub] sohami opened a new pull request #1587: DRILL-6934: Update the option documentation for planner.enable_unnest…

2018-12-27 Thread GitBox
sohami opened a new pull request #1587: DRILL-6934: Update the option documentation for planner.enable_unnest… URL: https://github.com/apache/drill/pull/1587 …_lateral This is an automated message from the Apache Git Service.

Re: [VOTE] Apache Drill release 1.15.0 - RC2

2018-12-27 Thread Sorabh Hamirwasia
- Downloaded src tarball from [3] and built on linux. - Built the cpp client on linux from source. - Tested Kerberos and Plain mechanism using querysubmitter and sqlline. - Verified Unnest/Lateral is enabled by default. ** The planner options documentation needs to be updated to reflect that featu

Drill performance tuning

2018-12-27 Thread Kiran Kumar Nandihalli Shetru (CONT)
Hi Team, I have the below condition: 1. I have a cluster of ec2 instances with 10 nodes of m4.4x large size. Meaning, each m4.4x large node would have 16 vCPUs and 64 G memory with 300 IOPs. Since I mentioned in override-conf all the 10 IPs, and because I am able to see all the drill instances in

Re: Drill performance tuning

2018-12-27 Thread Kiran Kumar Nandihalli Shetru (CONT)
Hi Team, > > I have the below condition: > > 1. I have a cluster of ec2 instances with 10 nodes of m4.4x large size. > Meaning, each m4.4x large node would have 16 vCPUs and 64 G memory with 300 > IOPs. Since I mentioned in override-conf all the 10 IPs, and because I am > able to see all the drill

Re: [VOTE] Apache Drill release 1.15.0 - RC2

2018-12-27 Thread Abhishek Girish
+1 - Brought up Drill in distributed mode on a 4 node cluster with MapR platform - looks good! - Ran regression tests from [6] - looks good! - Ran unit tests with default & mapr profile - looks good! - Basic sanity tests on Sqlline, Web UI - looks good! [6] https://github.com/mapr/drill-test-fram

[jira] [Created] (DRILL-6934) Update the option documentation for planner.enable_unnest_lateral

2018-12-27 Thread Sorabh Hamirwasia (JIRA)
Sorabh Hamirwasia created DRILL-6934: Summary: Update the option documentation for planner.enable_unnest_lateral Key: DRILL-6934 URL: https://issues.apache.org/jira/browse/DRILL-6934 Project: Apac

[GitHub] vdiravka commented on issue #1586: DRILL-6929: Exclude maprfs jar for default profile

2018-12-27 Thread GitBox
vdiravka commented on issue #1586: DRILL-6929: Exclude maprfs jar for default profile URL: https://github.com/apache/drill/pull/1586#issuecomment-450227449 +1 This is an automated message from the Apache Git Service. To respo

[GitHub] vdiravka commented on a change in pull request #1586: DRILL-6929: Exclude maprfs jar for default profile

2018-12-27 Thread GitBox
vdiravka commented on a change in pull request #1586: DRILL-6929: Exclude maprfs jar for default profile URL: https://github.com/apache/drill/pull/1586#discussion_r244222393 ## File path: contrib/storage-hive/core/scrMapr/main/java/org/apache/drill/exec/planner/sql/logical/ConvertH

[GitHub] vvysotskyi commented on a change in pull request #1586: DRILL-6929: Exclude maprfs jar for default profile

2018-12-27 Thread GitBox
vvysotskyi commented on a change in pull request #1586: DRILL-6929: Exclude maprfs jar for default profile URL: https://github.com/apache/drill/pull/1586#discussion_r244200965 ## File path: contrib/storage-hive/core/src/main/java/org/apache/drill/exec/store/hive/HiveStoragePlugin.j

[GitHub] vvysotskyi commented on a change in pull request #1586: DRILL-6929: Exclude maprfs jar for default profile

2018-12-27 Thread GitBox
vvysotskyi commented on a change in pull request #1586: DRILL-6929: Exclude maprfs jar for default profile URL: https://github.com/apache/drill/pull/1586#discussion_r244210746 ## File path: contrib/storage-hive/core/pom.xml ## @@ -142,11 +142,6 @@ -

[GitHub] vvysotskyi commented on a change in pull request #1586: DRILL-6929: Exclude maprfs jar for default profile

2018-12-27 Thread GitBox
vvysotskyi commented on a change in pull request #1586: DRILL-6929: Exclude maprfs jar for default profile URL: https://github.com/apache/drill/pull/1586#discussion_r244200475 ## File path: contrib/storage-hive/core/scrMapr/main/java/org/apache/drill/exec/planner/sql/logical/Conver

[GitHub] vvysotskyi commented on a change in pull request #1586: DRILL-6929: Exclude maprfs jar for default profile

2018-12-27 Thread GitBox
vvysotskyi commented on a change in pull request #1586: DRILL-6929: Exclude maprfs jar for default profile URL: https://github.com/apache/drill/pull/1586#discussion_r244212903 ## File path: contrib/storage-hive/core/src/main/java/org/apache/drill/exec/store/hive/HiveStoragePlugin.j

[jira] [Created] (DRILL-6933) Ctrl+Enter meta combo not working on Windows

2018-12-27 Thread Bridget Bevens (JIRA)
Bridget Bevens created DRILL-6933: - Summary: Ctrl+Enter meta combo not working on Windows Key: DRILL-6933 URL: https://issues.apache.org/jira/browse/DRILL-6933 Project: Apache Drill Issue Typ

Re: [VOTE] Apache Drill release 1.15.0 - RC2

2018-12-27 Thread Aman Sinha
- Downloaded source from [3] onto my Linux VM, built and ran unit tests. I had to run some test suites individually but got a clean run. - Verified extraneous directory issue (DRILL-6916) is resolved - Built the source using MapR profile and ran the secondary indexing tests within mapr format plug

[jira] [Created] (DRILL-6932) Drill can't submit Physical plan, returned by submitting Logical plan

2018-12-27 Thread Denys Ordynskiy (JIRA)
Denys Ordynskiy created DRILL-6932: -- Summary: Drill can't submit Physical plan, returned by submitting Logical plan Key: DRILL-6932 URL: https://issues.apache.org/jira/browse/DRILL-6932 Project: Apac

[GitHub] vdiravka commented on a change in pull request #1586: DRILL-6929: Exclude maprfs jar for default profile

2018-12-27 Thread GitBox
vdiravka commented on a change in pull request #1586: DRILL-6929: Exclude maprfs jar for default profile URL: https://github.com/apache/drill/pull/1586#discussion_r244185154 ## File path: contrib/storage-hive/core/src/main/java/org/apache/drill/exec/store/hive/HiveStoragePlugin.jav

[GitHub] vdiravka commented on a change in pull request #1586: DRILL-6929: Exclude maprfs jar for default profile

2018-12-27 Thread GitBox
vdiravka commented on a change in pull request #1586: DRILL-6929: Exclude maprfs jar for default profile URL: https://github.com/apache/drill/pull/1586#discussion_r244187396 ## File path: contrib/storage-hive/core/src/main/java/org/apache/drill/exec/store/hive/HiveStoragePlugin.jav

[GitHub] vdiravka commented on a change in pull request #1586: DRILL-6929: Exclude maprfs jar for default profile

2018-12-27 Thread GitBox
vdiravka commented on a change in pull request #1586: DRILL-6929: Exclude maprfs jar for default profile URL: https://github.com/apache/drill/pull/1586#discussion_r244193372 ## File path: contrib/storage-hive/core/pom.xml ## @@ -142,11 +142,6 @@ -

[GitHub] vdiravka commented on a change in pull request #1586: DRILL-6929: Exclude maprfs jar for default profile

2018-12-27 Thread GitBox
vdiravka commented on a change in pull request #1586: DRILL-6929: Exclude maprfs jar for default profile URL: https://github.com/apache/drill/pull/1586#discussion_r244180217 ## File path: contrib/storage-hive/core/scrMapr/main/java/org/apache/drill/exec/planner/sql/logical/ConvertH

[jira] [Created] (DRILL-6931) Drill "SHOW FILES" command duplicates empty S3 folders as subfolders

2018-12-27 Thread Denys Ordynskiy (JIRA)
Denys Ordynskiy created DRILL-6931: -- Summary: Drill "SHOW FILES" command duplicates empty S3 folders as subfolders Key: DRILL-6931 URL: https://issues.apache.org/jira/browse/DRILL-6931 Project: Apach

Re: Drill GitHub releases/tags

2018-12-27 Thread Karthikeyan Manivannan
+1 Looks like we have not been consistently creating Releases/Tags for all releases so, I guess, it is ok to remove these really old ones . On Thu, Dec 27, 2018 at 1:52 AM Vitalii Diravka wrote: > Hi Drill devs! > > Currently > https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_apac

[GitHub] vdiravka commented on a change in pull request #1559: DRILL-540: Allow querying hive views in Drill

2018-12-27 Thread GitBox
vdiravka commented on a change in pull request #1559: DRILL-540: Allow querying hive views in Drill URL: https://github.com/apache/drill/pull/1559#discussion_r244164782 ## File path: contrib/storage-hive/core/src/test/java/org/apache/drill/exec/impersonation/hive/TestStorageBasedHi

Re: Query on tables

2018-12-27 Thread Kiran Kumar NS
Hi Team, Is there any update on below questions, please Kind Regards Kiran Sent from my iPhone > On Dec 26, 2018, at 10:41 AM, Kiran Kumar NS wrote: > > Hi Vitalii, > > Thanks for getting back. > Yes, I did try it. But, I got the table is already present. It is because I > don’t want to c

[GitHub] ihuzenko commented on a change in pull request #1559: DRILL-540: Allow querying hive views in Drill

2018-12-27 Thread GitBox
ihuzenko commented on a change in pull request #1559: DRILL-540: Allow querying hive views in Drill URL: https://github.com/apache/drill/pull/1559#discussion_r244163749 ## File path: contrib/storage-hive/core/src/test/java/org/apache/drill/exec/impersonation/hive/TestStorageBasedHi

[GitHub] ihuzenko commented on a change in pull request #1559: DRILL-540: Allow querying hive views in Drill

2018-12-27 Thread GitBox
ihuzenko commented on a change in pull request #1559: DRILL-540: Allow querying hive views in Drill URL: https://github.com/apache/drill/pull/1559#discussion_r244163680 ## File path: contrib/storage-hive/core/src/main/java/org/apache/drill/exec/store/hive/HiveAuthorizationHelper.ja

[GitHub] ihuzenko commented on a change in pull request #1559: DRILL-540: Allow querying hive views in Drill

2018-12-27 Thread GitBox
ihuzenko commented on a change in pull request #1559: DRILL-540: Allow querying hive views in Drill URL: https://github.com/apache/drill/pull/1559#discussion_r244163534 ## File path: contrib/storage-hive/core/src/test/java/org/apache/drill/exec/impersonation/hive/TestSqlStdBasedAut

Re: [VOTE] Apache Drill release 1.15.0 - RC2

2018-12-27 Thread Denys Ordynskiy
- downloaded source code, successfully built Drill with mapr profile; - run Drill in distributed mode on Ubuntu on JDK8; - connected from Drill Explorer, explored data on S3 and MapRFS storage; - submitted some tests for Drill Web UI and Drill Rest API. +1 On Wed, Dec 26, 2018 at 8:40 PM Arina Ie

[GitHub] arina-ielchiieva commented on issue #1586: DRILL-6929: Exclude maprfs jar for default profile

2018-12-27 Thread GitBox
arina-ielchiieva commented on issue #1586: DRILL-6929: Exclude maprfs jar for default profile URL: https://github.com/apache/drill/pull/1586#issuecomment-450137849 @vdiravka could you please review? This is an automated messa

[GitHub] vvysotskyi opened a new pull request #1586: DRILL-6929: Exclude maprfs jar for default profile

2018-12-27 Thread GitBox
vvysotskyi opened a new pull request #1586: DRILL-6929: Exclude maprfs jar for default profile URL: https://github.com/apache/drill/pull/1586 - Moved dependency on `drill-format-mapr` into mapr profile in `contrib/storage-hive/core/pom.xml` - Moved class `ConvertHiveMapRDBJsonScanToDril

Re: Query on tables

2018-12-27 Thread Vitalii Diravka
Hi Kiran, You ask something similar to INSERT statements, but Drill doesn't support this functionality now [1]. Also CREATE OR REPLACE TABLE could be helpful for you (with additional work), but most databases don't support it [2]. You can write scripts with creating tables with different names in

Drill GitHub releases/tags

2018-12-27 Thread Vitalii Diravka
Hi Drill devs! Currently https://github.com/apache/drill/releases has a lot of old and useless Tags and Releases. Is it safe to remove all of them and upload the actual Drill releases there? I have created Jira ticket to track it: https://issues.apache.org/jira/browse/DRILL-6930 Kind regards Vit

[jira] [Created] (DRILL-6930) Creating Drill Releases Tags in GitHub

2018-12-27 Thread Vitalii Diravka (JIRA)
Vitalii Diravka created DRILL-6930: -- Summary: Creating Drill Releases Tags in GitHub Key: DRILL-6930 URL: https://issues.apache.org/jira/browse/DRILL-6930 Project: Apache Drill Issue Type: B