Showing posts with label character SET. Show all posts
Showing posts with label character SET. Show all posts

Wednesday, October 12, 2016

Convert Integer to date ESQL

DECLARE source INTEGER 20150401;
--DECLARE target CHARACTER;
--DECLARE pattern CHARACTER '00000000';
SET OutputRoot.XMLNSC.target = CAST(CAST(CAST(source AS CHARACTER FORMAT '00000000')AS DATE FORMAT 'yyyyMMdd')AS CHARACTER FORMAT 'yyyy-MM-dd') ||'T00:00:00.000';

Distributed Computing: A Guide to Comparing Data Between Hive Tables Using Spark

In big data, efficient data comparison is essential for ensuring data integrity and validating data migrations. Apache Spark, with its in-me...