Can someone pls help me creating regex pattern to use for creating a hive table with RegEx Serde....
I want hive regex table to be created with the pattern ^^^^^^^^^^ [10 anchor characters] as a delimiter! I am not sure what would be the regex pattern of hive table for this!!
Thanks a lot in advance
Thanks for the response @mqureshi
I Tried below two ways, but that did not work...
Any other thoughts i can try of ?
Hi @Raja A
In both cases the second one has only single slash. Can you try it with two slashes. I think the first one should work if you just add two slashes. Also, why not try to make it work with only "^^" first. Figure out how to make ^^ work and then you can simply extend that to ^^^^^^^^^^.
Thanks for your response and time @mqureshi
I tried for ^^... its still not working...!! And, sorry, my above comment had a typo !!
Below is what i am trying !!
create external table <table_name> ( col1 string, col2 string ) ROW FORMAT SERDE "org.apache.hadoop.hive.contrib.serde2.RegexSerDe" WITH SERDEPROPERTIES ( "input.regex" = "^^" ) STORED AS TEXTFILE LOCATION "<hdfs_path>";
I will try this on my machine when I get a chance, hopefully later today but I think it should
The first one signifies the beginning of a string and other two are for your matching pattern.