tag:blogger.com,1999:blog-6527688743456205256.post7278005535437558225..comments2023-12-18T09:38:33.215+11:00Comments on The Blas from Pas: Pivotal HD - Talking true SQL on HDFSPas Apicellahttp://www.blogger.com/profile/09389663166398991762noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-6527688743456205256.post-28791158401768595442013-09-20T01:57:52.523+10:002013-09-20T01:57:52.523+10:00To work on Pivotal HD 1.0.1 Single Node (VM), the ...To work on Pivotal HD 1.0.1 Single Node (VM), the SQL in step 4 should be:<br /><br />CREATE EXTERNAL TABLE person ( id int, name text) LOCATION ('pxf://pivhdsne:50070/person.txt?Fragmenter=HdfsDataFragmenter&Accessor=TextFileAccessor&Resolver=TextResolver') FORMAT 'TEXT' (DELIMITER = '|');<br />Anonymousnoreply@blogger.com