Re: Using SPLIT with DOT(.) delimiter demonstrate funny behavior within a VIEW

ed square brackets) split(reverse(split(reverse(floc),'/')[0]),'[.]')[0]   (need those square brackets)    From: Vivek Veeramani To: user@hive.apache.org; Sanjay Subramanian Sent: Monday, August 24, 2015 1:57 PM Subject: Re: Using SPLIT with DOT(.) delimiter

Re: Using SPLIT with DOT(.) delimiter demonstrate funny behavior within a VIEW

Hi Sanjay, Try replacing the 4 backslashes with just 2. Usually works with 2 backslashes. Replace this *split(reverse(split(reverse(**floc**),'/')[0]),'.')[0]* as resid with *split(reverse(split(reverse(floc**),'/')[0]),'\\.')[0]* as resid Please have a look and let us know if that h

Using SPLIT with DOT(.) delimiter demonstrate funny behavior within a VIEW

Hi guys I am using Hive version = 0.13.1-cdh5.3.3 HIVE TABLE =  qnap_resume_file_location---DROP  TABLE IF EXISTS      qnap_resume_file_location;CREATE EXTERNAL TABLE qnap_resume_file_location ( floc STRING     ) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t'