Teradata – Explain
EXPLAIN command returns the execution plan of parsing engine in English. It can be used with any SQL statement except on another EXPLAIN command. When a query is preceded with…
Teradata – Compression
Compression is used to reduce the storage used by the tables. In Teradata, compression can compress up to 255 distinct values including NULL. Since the storage is reduced, Teradata can…
Mahout – Environment
Pre-Installation Setup Before installing Hadoop into Linux environment, we need to set up Linux using ssh (Secure Shell). Follow the steps mentioned below for setting up the Linux environment. Creating a User…
Teradata – Statistics
Teradata optimizer comes up with an execution strategy for every SQL query. This execution strategy is based on the statistics collected on the tables used within the SQL query. Statistics…
Teradata – Secondary Index
A table can contain only one primary index. More often, you will come across scenarios where the table contains other columns, using which the data is frequently accessed. Teradata will…
Mahout – Machine Learning
Apache Mahout is a highly scalable machine learning library that enables developers to use optimized algorithms. Mahout implements popular machine learning techniques such as recommendation, classification, and clustering. Therefore, it…
Apache Pig – Foreach Operator
The FOREACH operator is used to generate specified data transformations based on the column data. Syntax Given below is the syntax of FOREACH operator. grunt> Relation_name2 = FOREACH Relatin_name1 GENERATE (required data); Example Assume…
Teradata – Space Concepts
There are three types of spaces available in Teradata. Permanent Space Permanent space is the maximum amount of space available for the user/database to hold data rows. Permanent tables, journals,…
Mahout
Apache Mahout is an open source project that is primarily used in producing scalable machine learning algorithms. This brief tutorial provides a quick introduction to Apache Mahout and explains how…
Teradata – Table Types
Teradata supports the following table types to hold temporary data. Derived TableVolatile TableGlobal Temporary Table Derived Table Derived tables are created, used and dropped within a query. These are used…
- Go to the previous page
- 1
- …
- 664
- 665
- 666
- 667
- 668
- 669
- 670
- …
- 739
- Go to the next page