Re: Correct way of using regexserde
Yes it is to create an external table that points your data with the regexp passed with the SERDE. good day 2013/7/2 Mohammad Tariq donta...@gmail.com Hello there, Thanks a lot for the response. Do you mean creating an external table?I have also tried deleting ouputregex, but same result. And the jar is also added. Warm Regards, Tariq cloudfront.blogspot.com On Mon, Jul 1, 2013 at 1:39 PM, Matouk IFTISSEN matouk.iftis...@ysance.com wrote: Hello, try to delete output.regex = %1$s and store your data in file then pricise where the file is located STORED AS TEXTFILE LOCATION '/..'; and assure that you add the jar hive-contrib-0.10.0.jar in the session or you have it in all Hadoop tasktrackers like this: add jar path_where_is_the_jar_in_hive_lib\hive-contrib-0.9.0.jar ; Good luck 2013/7/1 Mohammad Tariq donta...@gmail.com Hello list, I would really appreciate if someone could show me the correct way of using regexserde as i'm having some hard time using it. I have verified my regex through http://www.regexplanet.com/advanced/java/index.html and it's working fine there. But when i'm using the same pattern with regexserde i'm getting NULL. My input looks like this : SOME_CHARACTER_STRING and I want to extract the characters enclosed between the angle brackets. This is the command i'm using : hive CREATE TABLE s(f1 STRING) ROW FORMAT SERDE 'org.apache.hadoop.hive.contrib.serde2.RegexSerDe' WITH SERDEPROPERTIES ( input.regex = (\\w*), output.regex = %1$s) STORED AS TEXTFILE; LOAD works fine, but SELECT * gives me NULL. I am on hadoop-1.0.4 and hive-0.10.0 Thank you so much for you time. Warm Regards, Tariq cloudfront.blogspot.com
Re: Correct way of using regexserde
No luck. Warm Regards, Tariq cloudfront.blogspot.com On Tue, Jul 2, 2013 at 1:03 PM, Matouk IFTISSEN matouk.iftis...@ysance.comwrote: Yes it is to create an external table that points your data with the regexp passed with the SERDE. good day 2013/7/2 Mohammad Tariq donta...@gmail.com Hello there, Thanks a lot for the response. Do you mean creating an external table?I have also tried deleting ouputregex, but same result. And the jar is also added. Warm Regards, Tariq cloudfront.blogspot.com On Mon, Jul 1, 2013 at 1:39 PM, Matouk IFTISSEN matouk.iftis...@ysance.com wrote: Hello, try to delete output.regex = %1$s and store your data in file then pricise where the file is located STORED AS TEXTFILE LOCATION '/..'; and assure that you add the jar hive-contrib-0.10.0.jar in the session or you have it in all Hadoop tasktrackers like this: add jar path_where_is_the_jar_in_hive_lib\hive-contrib-0.9.0.jar ; Good luck 2013/7/1 Mohammad Tariq donta...@gmail.com Hello list, I would really appreciate if someone could show me the correct way of using regexserde as i'm having some hard time using it. I have verified my regex through http://www.regexplanet.com/advanced/java/index.html and it's working fine there. But when i'm using the same pattern with regexserde i'm getting NULL. My input looks like this : SOME_CHARACTER_STRING and I want to extract the characters enclosed between the angle brackets. This is the command i'm using : hive CREATE TABLE s(f1 STRING) ROW FORMAT SERDE 'org.apache.hadoop.hive.contrib.serde2.RegexSerDe' WITH SERDEPROPERTIES ( input.regex = (\\w*), output.regex = %1$s) STORED AS TEXTFILE; LOAD works fine, but SELECT * gives me NULL. I am on hadoop-1.0.4 and hive-0.10.0 Thank you so much for you time. Warm Regards, Tariq cloudfront.blogspot.com
Re: Correct way of using regexserde
Hello there, Thanks a lot for the response. Do you mean creating an external table?I have also tried deleting ouputregex, but same result. And the jar is also added. Warm Regards, Tariq cloudfront.blogspot.com On Mon, Jul 1, 2013 at 1:39 PM, Matouk IFTISSEN matouk.iftis...@ysance.comwrote: Hello, try to delete output.regex = %1$s and store your data in file then pricise where the file is located STORED AS TEXTFILE LOCATION '/..'; and assure that you add the jar hive-contrib-0.10.0.jar in the session or you have it in all Hadoop tasktrackers like this: add jar path_where_is_the_jar_in_hive_lib\hive-contrib-0.9.0.jar ; Good luck 2013/7/1 Mohammad Tariq donta...@gmail.com Hello list, I would really appreciate if someone could show me the correct way of using regexserde as i'm having some hard time using it. I have verified my regex through http://www.regexplanet.com/advanced/java/index.html and it's working fine there. But when i'm using the same pattern with regexserde i'm getting NULL. My input looks like this : SOME_CHARACTER_STRING and I want to extract the characters enclosed between the angle brackets. This is the command i'm using : hive CREATE TABLE s(f1 STRING) ROW FORMAT SERDE 'org.apache.hadoop.hive.contrib.serde2.RegexSerDe' WITH SERDEPROPERTIES ( input.regex = (\\w*), output.regex = %1$s) STORED AS TEXTFILE; LOAD works fine, but SELECT * gives me NULL. I am on hadoop-1.0.4 and hive-0.10.0 Thank you so much for you time. Warm Regards, Tariq cloudfront.blogspot.com
Correct way of using regexserde
Hello list, I would really appreciate if someone could show me the correct way of using regexserde as i'm having some hard time using it. I have verified my regex through http://www.regexplanet.com/advanced/java/index.html and it's working fine there. But when i'm using the same pattern with regexserde i'm getting NULL. My input looks like this : SOME_CHARACTER_STRING and I want to extract the characters enclosed between the angle brackets. This is the command i'm using : hive CREATE TABLE s(f1 STRING) ROW FORMAT SERDE 'org.apache.hadoop.hive.contrib.serde2.RegexSerDe' WITH SERDEPROPERTIES ( input.regex = (\\w*), output.regex = %1$s) STORED AS TEXTFILE; LOAD works fine, but SELECT * gives me NULL. I am on hadoop-1.0.4 and hive-0.10.0 Thank you so much for you time. Warm Regards, Tariq cloudfront.blogspot.com