Hello @ssubhas , the above worked however, when we try the same with LazySerde, it is able to escape the delimiter but loads few NULL values at the end. PFB snippet of statement I used: CREATE TABLE test1(5columns string) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' WITH SERDEPROPERTIES( 'separatorChar'='|', 'escapeChar'='\\' ) STORED AS INPUTFORMAT 'org.apache.hadoop.mapred.TextInputFormat' OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat';   NOTE: also tried field.delim=|, format.serialization=|. It works when serde properties are not mentioned and we use escape by Clause as you suggested, any way to make it work with LazySerde as well? (Data is Pipe delimited & may also have pipe in the data). Please suggest and help.                   ... View more

@nifiz @ssahi @kccensus2017  ... View more

The link to port forwarding is invalid !! Please assist.   Regards Raj ... View more

@pvillard How does this work exactly? Im having issues segmenting large files as well. When i split them do i do it multiple times or just once and then I can recombine them successively. Thanks for you help! ... View more

@Slim Ok, I performed my upgrade and Druid was installed successfully. Two notes: Superset is now it's own install (documentation does not appear updated for this), and in the service list it still says druid 0.9.2, however in the installed versions list it shows a proper 0.10.1 Otherwise I'm in business. Thanks for the help. ... View more

Well, it turns out that neither the ZooKeeper nor the Hive services were running. I started them and the Hive error went away. However, after restarting those services, I was still getting the a failure on the ATS check. Starting the YARN service resolved this. Thanks, Sonu. ... View more

FYI, the tutorial has recently been updated: Learning the Ropes of the Hortonworks Sandbox ... View more