hadoop - What is the substitute of LPAD of SQL in PIG -
i want convert below query in vertica pig.
sql query
substr(lpad(a,13,' '),1,1) a13
(a varchar variable)
there no lpad built in function available in pig.is there way can code in pig without writing udf. in advance.
if want convert sql query mapreduce job might more convenient switch hive supports common sql commands.
Comments
Post a Comment