Hi Chris,
The permissions or user id having access to Hadoop is struggling to create its home directory in HDFS. You could try adding the permissions manually to Hadoop.

Hi,

On the Hadoop machine, find the analogous file in the Hadoop configuration directory. In the file, find and copy the value of the configuration key yarn.application.classpath.

Below...

Thanks ChrisM@Work ,will try to use output data.

My thought:

If you want something, then you can achieve it. You will get all you want in life if you help enough other...

I want to use 2 statements in case of when matched clause

i.e

Update all the values of Vacancy.TB_FTSearchData

also

update the VacancyFTSupdated from table vacancy.TB_Vacancy

The Create table statements are

CREATE TABLE [Vacancy].[TB_Vacancy](

[VacancyInternalID] [bigint] IDENTITY(1,1) NOT NULL,

[VacancyExternalID] [nvarchar](40) NULL,

[VacancyReferenceNumber] [nvarchar](100) NULL,

[VacancyTitle] [nvarchar](400) NOT NULL,

[VacancyQuantity] [smallint] NULL,

[VacancyYearsOfExperience] [tinyint] NULL,

[VacancyCompetency] [nvarchar](max) NULL,

[VacancySalaryBaseRate] [numeric](14, 0) NULL,

[VacancySalaryTopRate] [numeric](14, 0) NULL,

[VacancySalaryFrequencyID]...

I am getting following errors

first time execution gives this error

Batch execution is terminated because of debugger request

second time execution gives this error

A transport-level error has occurred when sending the request...

But here I am getting one extra column which I don't want.

and also in other cases I need to use multiple case statement with order by because different datatype...

Thank you for your excellent solution now its working fine:w00t:

Hi,

Thanks 4 ur solution but I am getting error in order clause

Incorrect syntax near the keyword 'order'.

Incorrect syntax near the keyword 'ELSE'.

Incorrect syntax near the keyword 'ELSE'.

Nice example of order by using case