Hive Order by Vs Sort by

Today we will discuss about how and where we can use Order by and Sort by clause in Hive ORDER BY: è Forces all the data to go into the same reducer node, by doing this, Order by ensure that entire dataset is totally ordered è...

Read More

How to retrive/get all the numbers from a string using SQL server

Script for getting all the numbers from string DECLARE @string1 varchar(100)='welcome2sql1239hello23'; DECLARE @string2 varchar(100)='',@i int=0; WHILE @i<=LEN(@string1) BEGIN IF(SUBSTRING(@string1,@i,1)>='0' AND SUBSTRING(@string1,@i,1)<='9') SET @string2=@string2+SUBSTRING(@string1,@i,1); SET @i=@i+1; END SELECT @string2 AS...

Read More

Question: Find position of numbers in the given string

Script for finding the position of numbers in the given string DECLARE @input VARCHAR(100)='welcome2Sql376hi975'; DECLARE @output VARCHAR(100)=PATINDEX('%[0-9]%',@input); DECLARE @position VARCHAR(100)=@output; WHILE @output<LEN(@input) BEGIN SET @input=STUFF(@input,PARSE(@output AS BIGINT),1,'*'); SET @output=PATINDEX('%[0-9]%',@input); SET...

Read More