Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Explain about Skew Factor?

Answer Posted / yuvaevergreen

Below query can be used to find the distribution by amps.
SELECT HASHAMP(HASHBUCKET(HASHROW(index or column)))
,COUNT(*)
FROM TABLENAME GROUP BY 1 ORDER BY 2 DESC;

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

When tpump is used instead of multiload?

1108


What is the difference between fastload and multiload?

1389


What are teradata utilities?

1115


What are the various reporting tools in the market?

1074


What is teradata and why it is used?

1102


Mention a few of the ETL tools that come under Teradata.

1081


What is the use of virtual processor connectivity in teradata?

1036


Why does varchar occupy 2 extra bytes?

1201


What are the advantages of teradata?

1017


What is the purpose of upsert command?

1181


What do you mean by teradata intellicloud?

1039


Where is teradata rdbms used?

1104


What are the 5 phases in a multiload utility?

1037


What is basic teradata query language?

1118


How many types of joins are there in teradata?

979