Extract Table Statistics after Data import using Monet.Read.Csv

Hello,

I am trying to import a very large dataset of approx.. 170 million records.

The dataset is divided into have 12 tables of approx. 2 GB each. In order to recreate the entire dataset, I want to use the MERGE function to merge all the 12 tables into one dataset for further analysis.

However, when I try to add the table to merge table, it gives an error of type mismatch in columns.

Can you please help me how to determine the column type after a ‘csv’ file has been imported using monet.red.csv ?

I would like to use the same R interface to MonetDB as I am still learning MonetDB and not conversant with the DB.

Thanks & Regards, Jigar Shah Sent from Mail for Windows 10