Thu Aug 11, 2022 8:14 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 ( This legacy forum will be active and monitored during our transition to Stack Overflow but will become read only beginning September 1, 2022.

Modelling data for a web application

Comments or questions on structuring and organizing your data

Tue Jan 29, 2013 4:17 am Change Time Zone

I'm a HPCC beginner.

I sprayed multiple csv files using ECL and DFU and also have fetched the data using ECL record structure. I read that XML files can also be the input and that there is a JDBC driver too which supports read-only queries to the HPCC data.

In my Java-based web application, I'm currently using a MySQL database. It consists of several tables which have BLOB columns but the data arriving is huge and we have decided to switch to a HPCC for quick storage and retrieval.

My questions are as follows:

    How do insert my data directly into HPCC - I don't have any kind of file with me(csv, flat, xml etc.)?
    The BLOBs columns in the tables are the result of certain external operations which finish after the initial insert i.e the BLOBs are later 'updated' into the tables - how do I handle such a scenario in HPCC(ECL approach?)
Posts: 43
Joined: Mon Jul 23, 2012 11:23 am

Thu Jan 31, 2013 3:46 pm Change Time Zone

This has been addressed in another forum post:

Site Admin
Site Admin
Posts: 209
Joined: Thu Jan 27, 2011 10:58 am

Return to Data Modeling

Who is online

Users browsing this forum: No registered users and 2 guests