Extract 12 character from a string impala query
I have a column that contains productID,catalogID and organization.
For example 1000002121US200100 contains 1000002121=product ID, US20=catalogID, 01=product channel and finally 00=sales area.
I have a column that contains productID,catalogID and organization.
For example 1000002121US200100 contains 1000002121=product ID, US20=catalogID, 01=product channel and finally 00=sales area.