Member since
04-22-2016
931
Posts
46
Kudos Received
26
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
1374 | 10-11-2018 01:38 AM | |
1771 | 09-26-2018 02:24 AM | |
1696 | 06-29-2018 02:35 PM | |
2249 | 06-29-2018 02:34 PM | |
5105 | 06-20-2018 04:30 PM |
10-14-2018
03:06 AM
you mentioned that "clustered by" scatters the data within bucket but you didn't mention whats the advantage ? and how can it be exploited ? like partitioning we can give filters in the query . what about clustering ? how can the query benefit from it ?
... View more
10-14-2018
03:01 AM
can you give me an example on how to use the index after creation ? I am seeing all kinds of strange things just to use the index , don't know if its valid for hive 1.2.1 http://mail-archives.apache.org/mod_mbox/hive-user/201205.mbox/%3C60367909.283357.1337221656873.JavaMail.root@sms-zimbra-message-store-03.sms.scalar.ca%3E
... View more
10-12-2018
01:48 PM
after i create an index on hive table will the index be used in the query selecting from that table or do i have to select from the index itself ?
... View more
Labels:
10-11-2018
09:32 PM
I understand a PARTITIONED table with CLUSTERED BY clause will create groups of data files inside each partition but what if the table is created with just CLUSTERED BY into BUCKETS clause ? isnt it the same as a partitioned table since it will group the files together based on the clustered column ?
... View more
Labels:
10-11-2018
01:38 AM
ok i found the answer on apache site , starting hive 0.13 both syntax are supported . https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Joins
... View more
10-10-2018
09:58 PM
i am reading in documentation that hive only supports ANSI-SQL joins , but i can do a NON-ANSI-SQL join fine so does hive support both types of joins?
... View more
Labels:
10-10-2018
06:09 PM
ok I found out that just typing "set" gives all the settings but its huge , any filters I can use with the "set" command?
... View more
10-10-2018
06:05 PM
there are many parameters that we can set for a hive session like some shown below. how can I see what currently is set in my hive session ? set tez.grouping.split-count=4;
set hive.enforce.bucketing = true;
set hive.exec.dynamic.partition.mode = nonstrict;
... View more
Labels:
10-02-2018
05:23 PM
so in order to create a UDF , the user needs access to the Linux OS ? I thought the jar could also be created via the ambari hive view . whats the Hortonworks advise on this in terms of best practice?
... View more