test1.io

배치증적
CALL CSVWRITE (
'/tmp/out.csv',
'select * from INFORMATION_SCHEMA.TABLES',
'charset=UTF-8 fieldSeparator=, writeColumnHeader=true'
);


BATCH_JOB_EXECUTION_CONTEXT
CALL CSVWRITE (
'/tmp/BATCH_JOB_EXECUTION_CONTEXT.csv',
'select * from BATCH_JOB_EXECUTION_CONTEXT',
'charset=UTF-8 fieldSeparator=, writeColumnHeader=true'
);

BATCH_JOB_INSTANCE
CALL CSVWRITE (
'/tmp/BATCH_JOB_INSTANCE.csv',
'select * from BATCH_JOB_INSTANCE',
'charset=UTF-8 fieldSeparator=, writeColumnHeader=true'
);

BATCH_JOB_EXECUTION_PARAMS
CALL CSVWRITE (
'/tmp/BATCH_JOB_EXECUTION_PARAMS.csv',
'select * from BATCH_JOB_EXECUTION_PARAMS',
'charset=UTF-8 fieldSeparator=, writeColumnHeader=true'
);

BATCH_JOB_EXECUTION
CALL CSVWRITE (
'/tmp/BATCH_JOB_EXECUTION.csv',
'select * from BATCH_JOB_EXECUTION',
'charset=UTF-8 fieldSeparator=, writeColumnHeader=true'
);

BATCH_STEP_EXECUTION
CALL CSVWRITE (
'/tmp/BATCH_STEP_EXECUTION.csv',
'select * from BATCH_STEP_EXECUTION',
'charset=UTF-8 fieldSeparator=, writeColumnHeader=true'
);

BATCH_STEP_EXECUTION_CONTEXT
CALL CSVWRITE (
'/tmp/BATCH_STEP_EXECUTION_CONTEXT.csv',
'select * from BATCH_STEP_EXECUTION_CONTEXT',
'charset=UTF-8 fieldSeparator=, writeColumnHeader=true'
);


CALL CSVWRITE (
'/tmp/batch-history-2025-10-23.csv',
'SELECT
  bji.job_name,
  bji.job_instance_id,
  bje.job_execution_id,
  bje.create_time,
  bje.start_time,
  bje.end_time,
  bje.status,
  bje.exit_code,
  bje.exit_message,
  bje.last_updated
FROM (
  SELECT job_name, MAX(job_instance_id) AS max_id
  FROM batch_job_instance
  GROUP BY job_name
) latest
JOIN batch_job_instance bji
  ON bji.job_instance_id = latest.max_id
JOIN batch_job_execution bje
  ON bje.job_instance_id = bji.job_instance_id
WHERE bje.start_time >= ''2025-10-23 00:00:00''
  AND bje.start_time <  ''2025-10-23 23:59:59''
ORDER BY bje.start_time, bji.job_name',
'charset=UTF-8 fieldSeparator=, writeColumnHeader=true'
);