Sat Jun 25, 2022 7:58 pm
Login Register Lost Password? Contact Us

Please Note: The HPCC Systems forums are moving to Stack Overflow. We invite you to post your questions on Stack Overflow utilizing the tag hpcc-ecl (https://stackoverflow.com/search?tab=newest&q=hpcc-ecl). This legacy forum will be active and monitored during our transition to Stack Overflow but will become read only beginning September 1, 2022.



SQL to HPCC

Post questions or comments on how best to manage your big data problem

Wed Jun 29, 2011 2:57 pm Change Time Zone

My data is quickly out growing its current SQL based implementation (SQL Server / MySQL / Oracle etc). Is there any facilitation available to migrate to HPCC?
Helen
 
Posts: 3
Joined: Wed Jun 29, 2011 2:54 pm

Wed Jun 29, 2011 4:32 pm Change Time Zone

Hi Helen,

In the HPCC, you have the option to input data in one of three ways:

Fixed Length
Variable length (known as CSV)
XML

So the first step would be to export your SQL data into one of the supported formats. I think that most platforms support the CSV format, so that would be my first choice. After that, you simply copy the exported data to the Landing Zone and then spray from there. The Data Tutorial PDF has more information regarding this process.

Hope this helps!

Regards,

Bob Foreman
LexisNexis
[email protected]
 
Posts: 5
Joined: Thu Mar 31, 2011 4:39 pm

Thu Jul 14, 2011 7:52 pm Change Time Zone

Bob:

I think the question has more to do with migrating the data definitions, and querries etc that support the data than how do you simply move the data.

If so, It is interesting to note that the earliest versions of HPCC did support at least a subset of SQL, and wonder if any of that old code could be 'awoken' and given to the community?
SkipSnow
 
Posts: 9
Joined: Fri Jun 17, 2011 5:25 pm


Return to Managing Big Data

Who is online

Users browsing this forum: No registered users and 1 guest