Hive regex split a string in to two different fields

Question

my record is like:

0x0000110PPPP111KZY0 H123456789 XYZ 000000000000000000607532030000607532000060753203002014101707199999

I am searching for a regex where i can split first 3 char 0x0 in to one field in a hive table and the rest 000110PPPP111KZY0 in to second field and so on fixed length file and no delimiter.

can you give example of the result you want? at least 2 or 3 — Angga
– Angga, Commented Jul 29, 2015 at 2:40
how you want the third field? please provide sample result for the record given. — sras
– sras, Commented Jul 29, 2015 at 6:21

Izzy · Accepted Answer · 2015-07-29 03:33:11Z

1

I have no experience with hadoop or hive, however the following regex will work with what I believe you're looking for.

/(\dx\d)(.*)/ This will capture/split 0x0 into the first capture group, and everything afterwards into the second capture group. If you only want the numbers/letters following the 0x0 number (so none of the H123456789 or trailing words and letters), use /(\dx\d)([^ ]*)/

If I misunderstood what you're looking for, can you just clarify the exact section of that code you provided that you'd like to select and/or capture? Thanks!

answered Jul 29, 2015 at 3:33

Izzy

2721 silver badge14 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

mattinbits · Accepted Answer · 2015-07-29 09:34:33Z

0

Select 
  regexp_extract(data, '^(\\dx\\d).*', 1), 
  regexp_extract(data, '^\\dx\\d(.*)', 1) 
from (Select '0x0000110PPPP111KZY0 ' as data) a;

This code returns a Hive row with two fields:

0x0 000110PPPP111KZY0

edited Jul 29, 2015 at 9:34

answered Jul 29, 2015 at 8:30

mattinbits

10.4k1 gold badge28 silver badges35 bronze badges

Collectives™ on Stack Overflow

Hive regex split a string in to two different fields

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related