Drill Tableau Live connection issue

2018-09-12 Thread Divya Gehlot 
Hi,
I am facing a strange issue with Tableau Apache Drill live connection
Tableau Version : 10.4
MapR Drill Driver : MapRDrill_odbc_v1.3.13.1037
OS : Windows Server 2012

I have few numeric values in the view I  connected and When I describe it I
get
"The Single value is null" even for all the computation using that field
When I create the extract with the same connection , It all works fine

If any body uses Tableau for Drill Visualisation ,Appreciate the help !

Thanks,
Divya

Re: Drill Hangout tomorrow 08/21

2018-09-12 Thread Vitalii Diravka 
Oleksandr,

You couldn't connect to this hangout meeting. But you can share your ideas
in the answer to our last comment regarding Drill Metastore [1].
Could you please take a look?

[1]
https://issues.apache.org/jira/browse/DRILL-6552?focusedCommentId=16612437=com.atlassian.jira.plugin.system.issuetabpanels%3Acomment-tabpanel#comment-16612437

Kind regards
Vitalii


On Wed, Aug 22, 2018 at 8:28 AM Hanumath Rao Maduri 
wrote:

> Hangout attendees on 08/21:
> Pritesh, Salim, Hanumath, Boaz, Robert, Jyothsna, Karthik, Gautam, Vitalli,
> Vova, Parth, Olek
>
> Vitalli and Vova gave a presentation on Drill Metadata management project.
>
> Some of the questions which were discussed during the discussion.
> 1) Gautam suggested to use native operators for collecting stats instead of
> aggregation operators.
> 2) The metadata API should be made abstract such that metastore can use a
> dfs or hive metastore etc.
> 3) Schema change exception can be minimized by hive metastore but not
> totally overcome.
> 4) Discussion on how to refresh the metadata.
> 5) Caching the metadata and discussion on what problems the eariler caching
> solutions had in Drill.
>
>
> Further metadata discussion will be continued in the next hangout.
>
> -Hanu
>
> On Tue, Aug 21, 2018 at 9:53 AM Vitalii Diravka  >
> wrote:
>
> > Hi Alex,
> >
> > The issues pointed by you really exist. And using of HMS is still open
> > question.
> >
> > The main goal is to make Drill Metastore API, which can be used for
> > different Drill data sources. Then to adapt current Parquet metadata
> cache
> > files mechanism to this API.
> > It will be the first implementation. The second one could be HMS.
> > Although it has limitations, it has also benefits: it is easy to leverage
> > it in Drill, a lot of projects already use HMS (Spark, Presto ...),
> > so for some users it can be a good choice for storing metadata.
> >
> > Other implementations for Drill Metastore could be discussed (MetaCat,
> > WhereHow, new own implementation based on HBase/MapR-DB).
> >
> >
> > Kind regards
> > Vitalii
> >
> >
> > On Tue, Aug 21, 2018 at 7:04 PM Oleksandr Kalinin 
> > wrote:
> >
> > > 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 <
> > volody...@apache.org
> > > >
> > > 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 <
> > hanu@gmail.com
> > > >
> > > > 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
> >

Re: [IDEAS] Drill start up quotes

2018-09-12 Thread Charles Givre 
There are two types of analysts in the this world.  Those who use Drill and 
those who don’t. 

> On Sep 12, 2018, at 06:55, Bohdan Kazydub  wrote:
> 
> A query result is never late, nor is it early, it arrives precisely when it
> means to! (Gandalf)
> 
> Kind regards,
> Bohdan Kazydub
> 
> On Wed, Sep 12, 2018 at 1:14 PM, Vova Vysotskyi  wrote:
> 
>> Two things are infinite: the universe and drill; and I'm not sure about the
>> universe. (Albert Einstein)
>> If drill hasn't profoundly shocked you, you haven't understood it yet.
>> (Niels Bohr)
>> Drill gives you meaning and purpose, and life is empty without it. (Stephen
>> Hawking)
>> Drill must go on. (Queen)
>> 
>> Kind regards,
>> Volodymyr Vysotskyi
>> 
>> 
>> On Tue, Sep 11, 2018 at 11:36 PM Oleksandr Kalinin 
>> wrote:
>> 
>>> 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 <
>> eigenarb...@gmail.com
 
 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: [IDEAS] Drill start up quotes

2018-09-12 Thread Bohdan Kazydub 
A query result is never late, nor is it early, it arrives precisely when it
means to! (Gandalf)

Kind regards,
Bohdan Kazydub

On Wed, Sep 12, 2018 at 1:14 PM, Vova Vysotskyi  wrote:

> Two things are infinite: the universe and drill; and I'm not sure about the
> universe. (Albert Einstein)
> If drill hasn't profoundly shocked you, you haven't understood it yet.
> (Niels Bohr)
> Drill gives you meaning and purpose, and life is empty without it. (Stephen
> Hawking)
> Drill must go on. (Queen)
>
> Kind regards,
> Volodymyr Vysotskyi
>
>
> On Tue, Sep 11, 2018 at 11:36 PM Oleksandr Kalinin 
> wrote:
>
> > 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 <
> eigenarb...@gmail.com
> > >
> > > 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: [IDEAS] Drill start up quotes

2018-09-12 Thread Vova Vysotskyi 
Two things are infinite: the universe and drill; and I'm not sure about the
universe. (Albert Einstein)
If drill hasn't profoundly shocked you, you haven't understood it yet.
(Niels Bohr)
Drill gives you meaning and purpose, and life is empty without it. (Stephen
Hawking)
Drill must go on. (Queen)

Kind regards,
Volodymyr Vysotskyi


On Tue, Sep 11, 2018 at 11:36 PM Oleksandr Kalinin 
wrote:

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