Multi-character delimiter strings do not work correctly
-------------------------------------------------------

                 Key: HIVE-1762
                 URL: https://issues.apache.org/jira/browse/HIVE-1762
             Project: Hive
          Issue Type: Bug
          Components: Serializers/Deserializers
    Affects Versions: 0.5.0
            Reporter: Todd Lipcon


I was trying to give a demo using the movielens data set, which uses '::' as a 
delimiter (multiple characters). Using "FIELDS TERMINATED BY '::'" did not give 
an error, but it seems to just split on ':' rather than '::'.
{code}
hive> create table ml_ratings (userid int, movieid int, rating int, unixtime 
string) row format delimited  fields terminated by '::' stored as textfile;
...
hive> select * from ml_ratings limit 5;                                         
OK                                                    
1       NULL    122
1       NULL    185
{code}

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply via email to