HI , I want to query some sql table that contains ~80m rows. There is a few ways to do that and i wonder what is the best way to do that .
1. Using JDBCINPUTFORMAT -> convert to dataset and output it without doing any logic in the dataset, passing the full query in the JDBCINPUTFORMAT set query parameters. 2. Using JDBCINPUTFORMAT select all the data from table then desirelaze it ->convert to dataset and preforming logic. Or something else that is much efficient ? Thanks, Miki