package com.alibaba.druid.bvt.sql.odps.udf;
import com.alibaba.druid.support.opds.udf.ExportColumns;
import junit.framework.TestCase;
public class ExportColumnsTest0 extends TestCase {
private ExportColumns udf = new ExportColumns();
public void test_0() throws Exception {
String sql = "SELECT fund_base_cv_creative_ocr_judge_control_words_1422189630695(a.tfs, b.ocr_text, a.cates)"
+ "\n AS (tfs, control_word, ocr_word, control_type, cates)"
+ "\n FROM fund_base_cv_ad_auction_ocr_pv_tfs a"
+ "\n JOIN fund_base_cv_ad_auction_ocr_pv_tfs_ocr b ON a.tfs = b.tfs"
+ "\n WHERE a.ds=20150819 and b.ds=20150819;";
udf.evaluate(sql, "odps");
}
}