Re: [IDEAS] Drill start up quotes

2018-09-11 Thread Oleksandr Kalinin 
Some random ideas, not sure how appropriate - feel free to choose/modify as 
necessary :)

In use since 37 thousand years (according to Wikipedia, initial use of rotary 
instruments by homo sapiens is dated about 35000 BC)
It’s not just Bosch or Black+Decker (Two major elec. drill brands)
This drill bit is made of bits
This product is free of steel, cobalt and titanium (Typical drill bit materials)
Let’s drill something more solid than concrete
Eye and hearing protection are not required when using this drill
If only Mr Arnot knew ... (elec. drill inventor)

Cheers,
Alex

> On 11 Sep 2018, at 19:27, Arina Yelchiyeva  wrote:
> 
> Some quotes ideas:
> 
> drill never goes out of style
> everything is easier with drill
> 
> Kunal,
> regarding config, sounds reasonable, I'll do that.
> 
> Kind regards,
> Arina
> 
> 
> On Tue, Sep 11, 2018 at 12:17 AM Benedikt Koehler 
> wrote:
> 
>> You told me to drill sergeant! (Forrest Gump)
>> 
>> Benedikt
>> @furukama
>> 
>> 
>> Kunal Khatua  schrieb am Mo. 10. Sep. 2018 um 21:01:
>> 
>>> +1 on the suggestion.
>>> 
>>> I would also suggest that we change the backend implementation of the
>>> quotes to refer to a properties file (within the classpath) rather than
>>> have it hard coded within the SqlLine package.  This will ensure that new
>>> quotes can be added with every release without the need to touch the
>>> SqlLine fork for Drill.
>>> 
>>> ~ Kunal
>>> On 9/10/2018 7:06:59 AM, Arina Ielchiieva  wrote:
>>> Hi all,
>>> 
>>> we are close to SqlLine 1.5.0 upgrade which now has the mechanism to
>>> preserve Drill customizations. This one does include multiline support
>> but
>>> the next release might.
>>> You all know that one of the Drill customizations is quotes at startup. I
>>> was thinking we might want to fresh up the list a little bit.
>>> 
>>> Here is the current list:
>>> 
>>> start your sql engine
>>> this isn't your grandfather's sql
>>> a little sql for your nosql
>>> json ain't no thang
>>> drill baby drill
>>> just drill it
>>> say hello to my little drill
>>> what ever the mind of man can conceive and believe, drill can query
>>> the only truly happy people are children, the creative minority and drill
>>> users
>>> a drill is a terrible thing to waste
>>> got drill?
>>> a drill in the hand is better than two in the bush
>>> 
>>> If anybody has new serious / funny / philosophical / creative quotes
>>> ideas, please share and we can consider adding them to the existing list.
>>> 
>>> Kind regards,
>>> Arina
>>> 
>> --
>> 
>> --
>> Dr. Benedikt Köhler
>> Kreuzweg 4 • 82131 Stockdorf
>> Mobil: +49 170 333 0161 • Telefon: +49 89 857 45 84
>> Mail: bened...@eigenarbeit.org
>>

Re: Drill Hangout tomorrow 08/21

2018-08-21 Thread Oleksandr Kalinin 
Hi Volodymyr,

Just recalling on recent discussions in DEV list, it would be interesting
to see if following topics are addressed in the Drill metadata management
initiative:

1. Avoiding repetition of Hive mistakes (mainly relying on RDBMS)
Just to substantiate this point of view from practical experience, and if
we reflect on ambition to integrate and operate Drill in mission-critical
environment, following aspects could be listed:
  - Need of DBA support if cluster is subject to service level
objectives/agreements, which is somehow remote from Hadoop world. Need of
strong DBA skills if resulting DB workload is challenging in terms of
performance tuning.
  - Common RDBMS setups offer active-standby HA model. In secure
environments, e.g. environments which are subject to PCI-DSS compliancy,
that implies frequent OS patching and reboot (in reality every 30 days
max), thus causing an additional coordination effort and service outage for
duration of the failovers.
  - Active-active HA clusters like Galera / Percona are free of above
disadvantage, but require specific skill set which is not widespread in DBA
community. Also they are sensitive to even disk IO performance across the
cluster which may require additional hardware adjustment and IO isolation.
  - Need of backup / restore mechanism, which is probably lesser of concerns

2. Bottleneck in foreman when performing initial metadata collection (and
eventually pruning) on large amount of Parquet files
  - From discussion in the mailing list it was not fully clear whether
metastore will address it
  - Or shall this discussion be continued outside of metastore initiative
from your point of view?

I hope it would be OK with you and Vitalii to share some thoughts on this.

Thanks & Best Regards,
Alex

On Mon, Aug 20, 2018 at 10:50 PM Volodymyr Vysotskyi 
wrote:

> Hi all,
>
> I and Vitalii Diravka want to give the presentation with our ideas
> connected with Drill Metadata management project (DRILL-6552
> ).
>
> We will be happy to discuss it and choose the right way for further
> development.
>
> Kind regards,
> Volodymyr Vysotskyi
>
>
> On Mon, Aug 20, 2018 at 10:35 PM Hanumath Rao Maduri 
> wrote:
>
> > The Apache Drill Hangout will be held tomorrow at 10:00am PST; please let
> > us know should you have a topic for tomorrow's hangout. We will also ask
> > for topics at the beginning of the hangout.
> >
> > Hangout Link -
> > https://hangouts.google.com/hangouts/_/event/ci4rdiju8bv04a64efj5fedd0lc
> >
> > Regards,
> > Hanu
> >
>