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 <[email protected]> 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 <[email protected]> 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
> >>>>>>
>
