Hi, I am testing the above code in R and getting error as "Error in y[["k"]] : subscript out of bounds". mykmeansPoly <- function(x,y) { # get the number of clusters to be formed if(!is.null(y[['k']])) k=as.numeric(y[['k']]) else stop("Expected parameter k") # get the number of columns in the input ...

My directory containing more than 1000files. which command I need to write in copy command copy mdn.customer from '/home/dbadmin/customer/cust_?' delimiter '|' direct abort on error; copy mdn.customer from '/home/dbadmin/customer/*.log' delimiter '|' direct abort on error; Above commands are not wor...

Hi, 1.'/V/0/wowzahttpredir/vod/ep/mp4:/15649/iphone_M_R.mp4/playlist.m3u8?start=0' 2./L/0/_15797/QualityLevels(1017789)/Fragments(video=73455380000)/WowzaSessions(572378284)/tcdnorig(91e3ddee7 baec2a42b6c6a383a3e7c4981a8cf34fe140daada002f0b86c8dbcb).ismv 3.'/L/0/15397/manifest(format=m3u8-aapl).m3u8...

Hi, When I ran the below split_part query using dual queries,it is working fine but it is not working when I use copy command. select split_part('213.4.28.242|-|213.4.28.244|-|-|22/May/2013:15:52:12|GET|/I/0/_15449/QA_B101136Z13679366060.mp4|HTTP/1.1|-|206|104857600|104857600|0|1|TelCdn/0.1|','|',7)...

Input file is test.log 100.2.46.244|-|101.4.28.244|-|-|22/May/2010:15:52:12|GET|/I/0/_15449/QA_B101136Z13679366060.mp4|HTTP/1.1|-|206|104857600|104857600|0|1|Telcom/0.1| Output -------- Ip1 100.2.46.244 ip2 101.4.28.244 Datetime 22/May/2010:15:52:12 verb GET DT I DF 0 SID _15449 FileName QA_B101136Z...

Hi, I ran the below query copy cdn.inbound_access_log1 ( record filler varchar(65000), EndPoint_IP_Address as split_part(record,' ', 1), Client_IP_Address as split_part(record,' - ', 2), Request_Time as to_timestamp(regexp_substr(record, '\[([^]]+)]', 1,1,'',1), 'DD/Mon/YYYY:HH:MI:SS'), HTTP_Request...

Hi,

select regexp_substr('10.3.4.211 - 65.123.101.114 - - [21/May/2013:15:54:32] "GET /V','"\w+\s(/[^/]+)',1,1,' ',1) from dual

The above query is /V but I want only V..

Can you please check and modify regular expression accordingly?

Thanks in Advance