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 > > > >>>>>> > > > > > >
