Thanks Kunal, I will report a JIRA for that. Regards, Khurram
On Fri, Dec 28, 2018 at 9:59 AM Kunal Khatua <[email protected]> wrote: > The functions issue that Khurram reported is probably showing up due to > some new functions that might have been added. These might be internal > functions that dont seem to have been registered as such. > > Khurram, are the number of functions (select count * ...) different from > 1.14? > Please file a JIRA so that we can investigate this. > On 12/28/2018 6:05:38 AM, Vitalii Diravka <[email protected]> wrote: > Karthikeyan, > It looks like an env issue. I have sent you possible solution for that > failure. > > Khurram, > Not sure about your question. It is a new feature. > But you can send the separate mail to discuss whether it should be > improved or not in Drill 1.16.0. > > Kind regards > Vitalii > > > On Fri, Dec 28, 2018 at 6:34 AM Hanumath Rao Maduri > wrote: > > > - 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 > > > - 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 function names in the name column of sys.functions table in some > > cases, > > > are the operators, is this expected behavior, or should that column > have > > > actual names and not the operators. > > > > > > 0: jdbc:drill:schema=dfs.tmp> select distinct name from sys.functions > > limit > > > 12; > > > +--------+ > > > | name | > > > +--------+ > > > | != | > > > | $sum0 | > > > | && | > > > | - | > > > | /int | > > > | < |=""> > > > | <= |=""> > > > | <> | > > > | = | > > > | == | > > > | > | > > > | >= | > > > +--------+ > > > 12 rows selected (0.175 seconds) > > > > > > On Thu, Dec 27, 2018 at 3:02 PM Kunal Khatua wrote: > > > > > > > - 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: > > > > -- 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 > > > > 1.14.0 on my Mac (so it is a local environment issue). > > > > > > > > -- Manually ran on both Mac and Linux, and checked the Web-UI: All my > > > > `semijoin` tests, and memory spilling tests for hash-join and > > hash-aggr. > > > > And a select number of large queries. All passed OK. > > > > > > > > ==> +1 (binding) > > > > > > > > Thanks, > > > > > > > > Boaz > > > > > > > > On 12/27/18 12:54 PM, Abhishek Girish wrote: > > > > > +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://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_mapr_drill-2Dtest-2Dframework&d=DwIBaQ&c=cskdkSMqhcnjZxdQVpwTXg&r=PqKay2uOMZUqopDRKNfBtZSlsp2meGOxWNAVHxHnXCk&m=7tE7GD3UydzyDZaH_H0xw7V_m-XWe0tj8frqvjH2h7w&s=Q8PqbATc4VPUWvGcy_V_7iSQu9uyi1iCqLV5v1Mg31k&e= > > > > > > > > > > On Thu, Dec 27, 2018 at 11:12 AM Aman Sinha wrote: > > > > > > > > > >> - 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 plugin > > > > >> - Downloaded binary tar ball from [3] on my Mac. Verified checksum > > of > > > > the > > > > >> file using shasum -a 512 *file *and comparing with the one on [3] > > > > >> - Verified Vitalii's signature through the following command: gpg > > > > --verify > > > > >> Downloads/apache-drill-1.15.0.tar.gz.asc > apache-drill-1.15.0.tar.gz > > > > >> - Ran Drill in embedded mode and ran a few TPC-H queries. Checked > > > query > > > > >> profiles through Web UI > > > > >> > > > > >> LGTM. +1 > > > > >> > > > > >> Aman > > > > >> > > > > >> On Thu, Dec 27, 2018 at 6:17 AM Denys Ordynskiy > > > > >> wrote: > > > > >> > > > > >>> - 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 Ielchiieva > > > > >> wrote: > > > > >>>> Build from source on Linux, started in embedded mode, ran random > > > > >>> queries. > > > > >>>> Downloaded tarball on Windows, started Drill in embedded mode, > run > > > > >> random > > > > >>>> queries. > > > > >>>> Check Web UI: Profiles, Options, Plugins sections. > > > > >>>> > > > > >>>> Additionally checked: > > > > >>>> - information_schema files table; > > > > >>>> - new SqlLine version; > > > > >>>> - JDBC using Squirrel; > > > > >>>> - ODBC using Drill Explorer; > > > > >>>> - return result set option. > > > > >>>> > > > > >>>> +1 (binding) > > > > >>>> > > > > >>>> Kind regards, > > > > >>>> Arina > > > > >>>> > > > > >>>> On Wed, Dec 26, 2018 at 8:32 PM Volodymyr Vysotskyi > > > > >>> [email protected]> > > > > >>>> wrote: > > > > >>>> > > > > >>>>> - Downloaded built tar, checked signatures and hashes for built > > and > > > > >>>> source > > > > >>>>> tars > > > > >>>>> and for jars; > > > > >>>>> - run Drill in embedded mode on both Ubuntu and Windows on JDK8 > > and > > > > >>>> JDK11; > > > > >>>>> - created views, submitted random TPCH queries from UI and > > SqlLine, > > > > >>>> checked > > > > >>>>> that profiles are displayed correctly; > > > > >>>>> - downloaded source tar, ran unit tests and all tests are > passed; > > > > >>>>> - built with mapr profile, started in distributed mode, > submitted > > > > >>> several > > > > >>>>> tests for hive tables, checked logs, no errors are found; > > > > >>>>> - connected from SQuirrel, ran several queries, tested > > > > >>>>> exec.query.return_result_set_for_ddl > > > > >>>>> option; > > > > >>>>> - checked metadata correctness for decimal results; > > > > >>>>> - ran several queries from a Java application; > > > > >>>>> - built native client and submitted several queries. > > > > >>>>> > > > > >>>>> +1 (binding) > > > > >>>>> > > > > >>>>> Kind regards, > > > > >>>>> Volodymyr Vysotskyi > > > > >>>>> > > > > >>>>> > > > > >>>>> On Mon, Dec 24, 2018 at 9:27 PM Vitalii Diravka > > > > >>>>> wrote: > > > > >>>>> > > > > >>>>>> Hi all, > > > > >>>>>> > > > > >>>>>> I'd like to propose the second release candidate (rc2) of > Apache > > > > >>> Drill, > > > > >>>>>> version 1.15.0. > > > > >>>>>> > > > > >>>>>> Changes since the previous release candidate: fixed the > > > > >>> show-stoppers: > > > > >>>>>> DRILL-6919: Error: cannot find symbol in class > ServerSocketUtil > > > > >>>>>> DRILL-6920: Fix TestClient.testBasics() yarn test failure > > > > >>>>>> DRILL-6922: QUERY-level options are shown on Profiles tab > > > > >>>>>> DRILL-6925: Unable to generate Protobuf > > > > >>>>>> > > > > >>>>>> > > > > >>>>>> The release candidate covers a total of 205 resolved JIRAs > [1], > > > > >> [2]. > > > > >>>>>> Thanks to everyone who contributed to this release. > > > > >>>>>> > > > > >>>>>> The tarball artifacts are hosted at [3] and the maven > artifacts > > > are > > > > >>>>> hosted > > > > >>>>>> at [4]. > > > > >>>>>> > > > > >>>>>> This release candidate is based on commit > > > > >>>>>> 8743e8f1e8d5bca4d67c94d07a8560ad356ff2b6 located at [5]. > > > > >>>>>> > > > > >>>>>> Please download and try out the release. > > > > >>>>>> > > > > >>>>>> The vote ends at 7:00am UTC (11:00am PDT, 9:00pm EET, 12:30am > > > (next > > > > >>>> day) > > > > >>>>>> IST), Dec > > > > >>>>>> 28, 2018. It is one day longer, since 12/25/2018 is a holiday. > > > > >>>>>> > > > > >>>>>> [ ] +1 > > > > >>>>>> [ ] +0 > > > > >>>>>> [ ] -1 > > > > >>>>>> > > > > >>>>>> Here's my vote: +1 > > > > >>>>>> > > > > >>>>>> [1] > > > > >>> > > > > > > > > > > https://urldefense.proofpoint.com/v2/url?u=https-3A__issues.apache.org_jira_projects_DRILL_versions_12343317&d=DwIBaQ&c=cskdkSMqhcnjZxdQVpwTXg&r=PqKay2uOMZUqopDRKNfBtZSlsp2meGOxWNAVHxHnXCk&m=7tE7GD3UydzyDZaH_H0xw7V_m-XWe0tj8frqvjH2h7w&s=8UC4l_5h1brNiQ4MXawvPduc09kbi9k0wxN_fdwWwxk&e= > > > > >>>>>> [2] > > > > >>>>>> > > > > >>>>>> > > > > >> > > > > > > > > > > https://urldefense.proofpoint.com/v2/url?u=https-3A__issues.apache.org_jira_secure_ReleaseNote.jspa-3Fversion-3D12343317-26styleName-3D-26projectId-3D12313820&d=DwIBaQ&c=cskdkSMqhcnjZxdQVpwTXg&r=PqKay2uOMZUqopDRKNfBtZSlsp2meGOxWNAVHxHnXCk&m=7tE7GD3UydzyDZaH_H0xw7V_m-XWe0tj8frqvjH2h7w&s=X385VEZwZ__symMXg97TArRPK7h_lSHpTxgLV3hDEB0&e= > > > > >>>>>> [3] > > > > > > > > > > https://urldefense.proofpoint.com/v2/url?u=http-3A__home.apache.org_-7Evitalii_drill_releases_1.15.0_rc2_&d=DwIBaQ&c=cskdkSMqhcnjZxdQVpwTXg&r=PqKay2uOMZUqopDRKNfBtZSlsp2meGOxWNAVHxHnXCk&m=7tE7GD3UydzyDZaH_H0xw7V_m-XWe0tj8frqvjH2h7w&s=_n9eTukhAnX8gRij-UTyXrXq92W9SAwti44dWqstLEQ&e= > > > > >>>>>> [4] > > > > >>>>>> > > > > >> > > > > > > > > > > https://urldefense.proofpoint.com/v2/url?u=https-3A__repository.apache.org_content_repositories_orgapachedrill-2D1062_&d=DwIBaQ&c=cskdkSMqhcnjZxdQVpwTXg&r=PqKay2uOMZUqopDRKNfBtZSlsp2meGOxWNAVHxHnXCk&m=7tE7GD3UydzyDZaH_H0xw7V_m-XWe0tj8frqvjH2h7w&s=tIaZOpH-UQWTSDuYLUabOtn-BQZkbKb1o2ki6rIqto4&e= > > > > >>>>>> [5] > > > > > > > > > > https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_vdiravka_drill_commits_drill-2D1.15.0&d=DwIBaQ&c=cskdkSMqhcnjZxdQVpwTXg&r=PqKay2uOMZUqopDRKNfBtZSlsp2meGOxWNAVHxHnXCk&m=7tE7GD3UydzyDZaH_H0xw7V_m-XWe0tj8frqvjH2h7w&s=QedIzlU9ur-Dsg4WCLd0SvGBLm2q5wemucenejFW-_0&e= > > > > >>>>>> > > > > >>>>>> Kind regards > > > > >>>>>> Vitalii > > > > >>>>>> > > > > > > > > > >
