About aliyesami

aliyesami · ‎10-14-2018

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 ?

aliyesami · ‎10-14-2018

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

aliyesami · ‎10-12-2018

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 ?

aliyesami · ‎10-12-2018

can anyone address this question ?

aliyesami · ‎10-11-2018

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 ?

aliyesami · ‎10-11-2018

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

aliyesami · ‎10-10-2018

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?

aliyesami · ‎10-10-2018

ok I found out that just typing "set" gives all the settings but its huge , any filters I can use with the "set" command?

aliyesami · ‎10-10-2018

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;

aliyesami · ‎10-02-2018

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?

Online	Offline
Last Visited	‎11-03-2016 03:37 PM

Member Since	‎04-22-2016 08:38 AM
Last Visited	‎11-03-2016 03:37 PM
Posts	931
Kudos received	46

Cloudera Community

Re: NON-ANSI JOIN in hive

Re: insert query hangs from hive view ONLY

Re: cant start rest server

Re: hbase rest api failing

Re: how to read time reported by yarn

Re: question about clustered only table

Re: index in hive question

index in hive question

Re: question about clustered only table

question about clustered only table

Re: NON-ANSI JOIN in hive

NON-ANSI JOIN in hive

Re: how to view hive cli settings

how to view hive cli settings

Re: creating UDFs from ambari view