Hi, If you ssh xxx.xxx.xxx.xxx -p 22 you'll be in Centos and you'll be able to use root. For this, use with ALT+F5 or putty. If you ssh xxx.xxx.xxx.xxx -p 2222 you'll be connected to the sandbox (ie docker). In docker, you'll be able to use the predefined accounts (maria_dev, raj_ops, ... ) but not root... guess why ;-). ... View more

Actually I refer to a complete schema as soon as possible. First when I describe it when loading the hive table, then when I transform data. Works fine for me when I need to clean fields with complex criterias within the same table. A = LOAD 'hive_table' USING org.apache.hive.hcatalog.pig.HCatLoader() as (f0: chararray,f1: chararray,f2: chararray; B = FOREACH A GENERATE $0 as (f0:chararray),$1 as (f1:chararray),REPLACE($2,'John Doe','Mr Bean') as (f2:chararray); STORE B INTO 'hive_table' using org.apache.hive.hcatalog.pig.HCatStorer(); ... View more