Pig Datatypes

Numeric datatypes

int

  • Singned 32-bit integer
  • Example: 8 (or) 5 (or) any number

long

  • Singned 64-bit integer
  • Example: 5L (or) 5l

float

  • 32-bit floating point
  • Example: 5.5F (or) 5.5f (or) 5.0f (or) any number with decimal 

    (early version, recently float has been dropped)

double

  • 64-bit floating point
  • Example: 10.5 (or) 5.0 (or) 1.5 (or) 1.5e2 (or) 1.5E2 (or) any number with decimal

Non-numeric or Arrays datatype

chararray 

  • character array(string)
  • Example: 'karpagaraj' or 'hello there' or any string

bytearray

  • blob
  • Example: any binary data

Non-numeric datatype

  • boolean
    • true or false (case sensitive)
  • datetime
    • Example 1970-01-01T00:00:00.000+00:00
  • null
    • unknown or data missing or any data element can be null.

Complex datatype

tuple

  • ordered set of fields
  • Example: (1,3) like that

bag

  • collection of tuples
  • Example: {(1,3),(4,6)}

map

  • collection of tuples: set of key/value pairs
  • Example: [k1#v1, k2#v2]

atom 

  • any single value in Pig Latin, irrespective of their data, type is known as "Atom".
  • A piece of data or a simple atomic value is known as a "field". 
  • It is a simple atomic data value. It is stored as a string but can be used as either a string or a number. 
  • Various atomic values of Pig are int, long, float, double, chararray, and byte array.
  • Example − 'raja' or '30'

Comments

Post a Comment

Popular posts from this blog

Hive File Formats

Image
 Hive supports several file formats: Text File SequenceFile RCFile Avro Files ORC Files Parquet Custom INPUTFORMAT and OUTPUTFORMAT      The hive.default.fileformat configuration parameter which is avaialble in hive-site.xml determines the format to use if it is not specified in a CREATE TABLE or ALTER TABLE statement.        Text file is the parameter's default value. What is File Format ? File Format is a way in which information is stored or encoded in a computer file.  In Hive it refers to how records are stored inside the file. These file formats mainly vary between data encoding, compression rate, usage of space and disk I/O. Hive does not verify whether the data that you are loading matches the schema for the table or not. However, it verifies if the file format matches the table definition or not. Text File TEXT FILE format is a famous input/output format used in Hadoop. In Hive if we define a table as TEXTFILE it can load data o...
Read more

Why We Need Hadoop?

What is Hadoop? It is an open source framework or system which was fully developed by Java.  It is allow us to implement Big Data.  Hadoop can be used for storing and processing huge datasets with cluster of commodity hardware. Because its stores the data and processing in a distributed manner.  It made up of several components which entirely open source. Doug Cutting is the inventor of hadoop. He used elephant symbol. His child used to play with elephant toy. So he used that toy name as symbol and named for new invention. Why we need to go for Hadoop? 1. High Throughput and Low latency queries Less amount of time it will take to run/process real time queries or near real time queires. We can achieve high throughput in hadoop using below techniques.  Parallel Processing WORM Data Locality 2. Distributed computing A distributed computer system consists of multiple software components that are on multiple computers, but run as a single system.  The computers that ...
Read more

Hive Data Types

Image
 All the data types in Hive are classified into four types, given as follows: Column Types Literals Null Values Misc Types Complex Types Column Types Integral Types Integer type data can be specified using integral data types, INT. When the data range exceeds the range of INT, you need to use BIGINT and if the data range is smaller than the INT, you use SMALLINT. TINYINT is smaller than SMALLINT. The data ranges for TINYINT, SMALLINT, INT, BIGINT is below, TINYINT (1-byte signed integer, from -128 to 127) SMALLINT (2-byte signed integer, from -32,768 to 32,767) INT (4-byte signed integer, from -2,147,483,648 to 2,147,483,647) BIGINT (8-byte signed integer, from -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807) Example create table test1(id tinyint) row format delimited fields terminated by ','; insert into test1 values(1); insert into test1 values(127); insert into test1 values(128); hive> select * from test1; OK 1 127 NULL Time taken: 0.055 seconds, Fetched: 3 row(s)...
Read more