org.apache.pig.piggybank.storage

Class DBStorage

java.lang.Object

org.apache.pig.StoreFunc

org.apache.pig.piggybank.storage.DBStorage

All Implemented Interfaces:

StoreFuncInterface

public class DBStorage
extends StoreFunc

Field Summary

Fields

Modifier and Type	Field and Description
protected ResourceSchema	schema

Constructor Summary

Constructors

Constructor and Description
DBStorage(String driver, String jdbcURL, String insertQuery)
DBStorage(String driver, String jdbcURL, String user, String pass, String insertQuery)
DBStorage(String driver, String jdbcURL, String user, String pass, String insertQuery, String batchSize)

Method Summary

Methods

Modifier and Type	Method and Description
void	checkSchema(ResourceSchema s) Set the schema for data to be stored.
org.apache.hadoop.mapreduce.OutputFormat	getOutputFormat() Return the OutputFormat associated with StoreFunc.
void	prepareToWrite(org.apache.hadoop.mapreduce.RecordWriter writer) Initialise the database connection and prepared statement here.
void	putNext(Tuple tuple) Write the tuple to Database directly here.
void	setStoreFuncUDFContextSignature(String signature) This method will be called by Pig both in the front end and back end to pass a unique signature to the StoreFunc which it can use to store information in the UDFContext which it needs to store between various method invocations in the front end and back end.
void	setStoreLocation(String location, org.apache.hadoop.mapreduce.Job job) Communicate to the storer the location where the data needs to be stored.
protected int	sqlDataTypeFromPigDataType(byte pigDataType)
Boolean	supportsParallelWriteToStoreLocation() DAG execution engines like Tez support optimizing union by writing to output location in parallel from tasks of different vertices.

Methods inherited from class org.apache.pig.StoreFunc

cleanupOnFailure, cleanupOnFailureImpl, cleanupOnSuccess, relToAbsPathForStoreLocation, warn

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

schema

protected ResourceSchema schema

Constructor Detail

DBStorage

public DBStorage(String driver,
         String jdbcURL,
         String insertQuery)

DBStorage

public DBStorage(String driver,
         String jdbcURL,
         String user,
         String pass,
         String insertQuery)
          throws SQLException

Throws:

SQLException

DBStorage

public DBStorage(String driver,
         String jdbcURL,
         String user,
         String pass,
         String insertQuery,
         String batchSize)
          throws RuntimeException

Throws:

RuntimeException

Method Detail

putNext

public void putNext(Tuple tuple)
             throws IOException

Write the tuple to Database directly here.

Specified by:

putNext in interface StoreFuncInterface

Specified by:

putNext in class StoreFunc

Parameters:

tuple - the tuple to store.

Throws:

IOException - if an exception occurs during the write

sqlDataTypeFromPigDataType

protected int sqlDataTypeFromPigDataType(byte pigDataType)

getOutputFormat

public org.apache.hadoop.mapreduce.OutputFormat getOutputFormat()
                                                         throws IOException

Description copied from class: StoreFunc

Return the OutputFormat associated with StoreFunc. This will be called on the front end during planning and on the backend during execution.

Specified by:

getOutputFormat in interface StoreFuncInterface

Specified by:

getOutputFormat in class StoreFunc

Returns:

the OutputFormat associated with StoreFunc

Throws:

IOException - if an exception occurs while constructing the OutputFormat

prepareToWrite

public void prepareToWrite(org.apache.hadoop.mapreduce.RecordWriter writer)
                    throws IOException

Initialise the database connection and prepared statement here.

Specified by:

prepareToWrite in interface StoreFuncInterface

Specified by:

prepareToWrite in class StoreFunc

Parameters:

writer - RecordWriter to use.

Throws:

IOException - if an exception occurs during initialization

setStoreLocation

public void setStoreLocation(String location,
                    org.apache.hadoop.mapreduce.Job job)
                      throws IOException

Description copied from class: StoreFunc

Communicate to the storer the location where the data needs to be stored. The location string passed to the StoreFunc here is the return value of StoreFunc.relToAbsPathForStoreLocation(String, Path) This method will be called in the frontend and backend multiple times. Implementations should bear in mind that this method is called multiple times and should ensure there are no inconsistent side effects due to the multiple calls. StoreFunc.checkSchema(ResourceSchema) will be called before any call to StoreFunc.setStoreLocation(String, Job).

Specified by:

setStoreLocation in interface StoreFuncInterface

Specified by:

setStoreLocation in class StoreFunc

Parameters:

location - Location returned by StoreFunc.relToAbsPathForStoreLocation(String, Path)

job - The Job object

Throws:

IOException - if the location is not valid.

setStoreFuncUDFContextSignature

public void setStoreFuncUDFContextSignature(String signature)

Description copied from class: StoreFunc

This method will be called by Pig both in the front end and back end to pass a unique signature to the StoreFunc which it can use to store information in the UDFContext which it needs to store between various method invocations in the front end and back end. This method will be called before other methods in StoreFunc. This is necessary because in a Pig Latin script with multiple stores, the different instances of store functions need to be able to find their (and only their) data in the UDFContext object. The default implementation is a no-op.

Specified by:

setStoreFuncUDFContextSignature in interface StoreFuncInterface

Overrides:

setStoreFuncUDFContextSignature in class StoreFunc

Parameters:

signature - a unique signature to identify this StoreFunc

checkSchema

public void checkSchema(ResourceSchema s)
                 throws IOException

Description copied from class: StoreFunc

Set the schema for data to be stored. This will be called on the front end during planning if the store is associated with a schema. A Store function should implement this function to check that a given schema is acceptable to it. For example, it can check that the correct partition keys are included; a storage function to be written directly to an OutputFormat can make sure the schema will translate in a well defined way. Default implementation is a no-op.

Specified by:

checkSchema in interface StoreFuncInterface

Overrides:

checkSchema in class StoreFunc

Parameters:

s - to be checked

Throws:

IOException - if this schema is not acceptable. It should include a detailed error message indicating what is wrong with the schema.

supportsParallelWriteToStoreLocation

public Boolean supportsParallelWriteToStoreLocation()

Description copied from class: StoreFunc

DAG execution engines like Tez support optimizing union by writing to output location in parallel from tasks of different vertices. Commit is called once all the vertices in the union are complete. This eliminates need to have a separate phase to read data output from previous phases, union them and write out again. Enabling the union optimization requires the OutputFormat to 1) Support creation of different part file names for tasks of different vertices. Conflicting filenames can create data corruption and loss. For eg: If task 0 of vertex1 and vertex2 both create filename as part-r-00000, then one of the files will be overwritten when promoting from temporary to final location leading to data loss. FileOutputFormat has mapreduce.output.basename config which enables naming files differently in different vertices. Classes extending FileOutputFormat and those prefixing file names with mapreduce.output.basename value will not encounter conflict. Cases like HBaseStorage which write to key value store and do not produce files also should not face any conflict. 2) Support calling of commit once at the end takes care of promoting temporary files of the different vertices into the final location. For eg: FileOutputFormat commit algorithm handles promoting of files produced by tasks of different vertices into final output location without issues if there is no file name conflict. In cases like HBaseStorage, the TableOutputCommitter does nothing on commit. If custom OutputFormat used by the StoreFunc does not support the above two criteria, then false should be returned. Union optimization will be disabled for the StoreFunc. Default implementation returns null and in that case planner falls back to PigConfiguration.PIG_TEZ_OPT_UNION_SUPPORTED_STOREFUNCS and PigConfiguration.PIG_TEZ_OPT_UNION_UNSUPPORTED_STOREFUNCS settings to determine if the StoreFunc supports it.

Overrides:

supportsParallelWriteToStoreLocation in class StoreFunc