using csvJDBC with mapreduce

Question

I want to execute Select query on CSV file using csvJDBC with MapReduce.

I'm using the following code in a Map-Only function, but the output file is empty:

         public void map(LongWritable key, Text value, Context context) throws IOException, InterruptedException {

        // Load the driver.
            try {
                Class.forName("org.relique.jdbc.csv.CsvDriver");
                // Create a connection. The first command line parameter is
                // the directory containing the .csv files.
               String csv1 = csv.substring(0, csv.indexOf("file.csv"));
                Connection conn = DriverManager.getConnection("jdbc:relique:csv:" + csv1);

                // Create a Statement object to execute the query with.
                // A Statement is not thread-safe.
                Statement stmt = conn.createStatement();


                ResultSet results = stmt.executeQuery(input);

                // Dump out the results to a CSV file with the same format
                // using CsvJdbc helper function

                while (results.next())
                  {

                      out.set(results.getString("id")); 
                      context.write( out, new IntWritable(1));
                  }

                // Clean up
                conn.close();
            } catch (ClassNotFoundException | SQLException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }