Re: How useful are tools for Hive data modeling

2020-11-11 Thread Panos Garefalakis
gt;>>- https://issues.apache.org/jira/browse/HIVE-18715 >>> >>> >>> Thanks, >>> Peter >>> >>> On Nov 11, 2020, at 17:25, Mich Talebzadeh >>> wrote: >>> >>> Hi all, >>> >>> I wrote th

Re: How useful are tools for Hive data modeling

2020-11-11 Thread Austin Hackett
wse/HIVE-18715> >> >> Thanks, >> Peter >> >>> On Nov 11, 2020, at 17:25, Mich Talebzadeh >> <mailto:mich.talebza...@gmail.com>> wrote: >>> >>> Hi all, >>> >>> I wrote these notes earlier this year. &

Re: How useful are tools for Hive data modeling

2020-11-11 Thread Mich Talebzadeh
; Hi all, >> >> I wrote these notes earlier this year. >> >> I heard today that someone mentioned Hive 1 does not support indexes but >> hive 2 does. >> >> I still believe that Hive does not support indexing as per below. Has >> this been changed? >>

Re: How useful are tools for Hive data modeling

2020-11-11 Thread Austin Hackett
ut >> hive 2 does. >> >> I still believe that Hive does not support indexing as per below. Has this >> been changed? >> >> Regards, >> >> Mich >> >> -- Forwarded message - >> From: Mich Talebzadeh > <mai

Re: How useful are tools for Hive data modeling

2020-11-11 Thread Mich Talebzadeh
--- Forwarded message ----- > From: Mich Talebzadeh > Date: Thu, 2 Apr 2020 at 12:17 > Subject: How useful are tools for Hive data modeling > To: user > > > Hi, > > Fundamentally Hive tables have structure and support provided by desc > formatted and s

Re: How useful are tools for Hive data modeling

2020-11-11 Thread Peter Vary
s > been changed? > > Regards, > > Mich > > -- Forwarded message - > From: Mich Talebzadeh <mailto:mich.talebza...@gmail.com>> > Date: Thu, 2 Apr 2020 at 12:17 > Subject: How useful are tools for Hive data modeling > To: user mailto:user@hiv

Fwd: How useful are tools for Hive data modeling

2020-11-11 Thread Mich Talebzadeh
Talebzadeh Date: Thu, 2 Apr 2020 at 12:17 Subject: How useful are tools for Hive data modeling To: user Hi, Fundamentally Hive tables have structure and support provided by desc formatted and show partitions . Hive does not support indexes in real HQL operations (I stand corrected). So what we

How useful are tools for Hive data modeling

2020-04-02 Thread Mich Talebzadeh
Hi, Fundamentally Hive tables have structure and support provided by desc formatted and show partitions . Hive does not support indexes in real HQL operations (I stand corrected). So what we have are tables, partitions and clustering (AKA hash partitioning). Hive does not support indexes