@Test public void elementsOfArrayCaseInsensitive() throws Exception { String query = String.format("select t.\"MARKETING_INFO\".keywords[0] as keyword0, t.\"Marketing_Info\".Keywords[2] as keyword2 from %s t", DATAFILE); String[] columns = {"keyword0", "keyword2"}; testBuilder() .sqlQuery(query) .unOrdered() .jsonBaselineFile("store/parquet/complex/baseline4.json") .baselineColumns(columns) .build() .run(); }
@Test public void elementsOfArray() throws Exception { String query = String.format("select t.\"marketing_info\".keywords[0] as keyword0, t.\"marketing_info\".keywords[2] as keyword2 from %s t", DATAFILE); String[] columns = {"keyword0", "keyword2"}; testBuilder() .sqlQuery(query) .unOrdered() .jsonBaselineFile("store/parquet/complex/baseline4.json") .baselineColumns(columns) .build() .run(); }
@Test public void secondElementInMap() throws Exception { String query = String.format("select t.\"marketing_info\".keywords as keywords from %s t", DATAFILE); String[] columns = {"keywords"}; testBuilder() .sqlQuery(query) .ordered() .jsonBaselineFile("store/parquet/complex/baseline3.json") .baselineColumns(columns) .build() .run(); }
@Test //DRILL-3533 @Ignore("json null type") public void notxistsField() throws Exception { String query = String.format("select t.\"marketing_info\".notexists as notexists, t.\"marketing_info\".camp_id as id from %s t", DATAFILE); String[] columns = {"notexists", "id"}; testBuilder() .sqlQuery(query) .unOrdered() .jsonBaselineFile("store/parquet/complex/baseline8.json") .baselineColumns(columns) .build() .run(); }
@Test @Ignore public void missingColumnInMap() throws Exception { String query = "select t.trans_info.keywords as keywords from cp.\"store/parquet/complex/complex.parquet\" t"; String[] columns = {"keywords"}; testBuilder() .sqlQuery(query) .ordered() .jsonBaselineFile("store/parquet/complex/baseline2.json") .baselineColumns(columns) .build() .run(); }
private void runFilterNonComplexColumn() throws Exception { String query = String.format("select t1.user_info.cust_id as cust_id from %s t1 where t1.trans_id > 0 and " + "t1.trans_id < 4", DATAFILE); TestBuilder builder = testBuilder() .sqlQuery(query) .unOrdered() .jsonBaselineFile("store/parquet/complex/baseline.json") .baselineColumns("cust_id"); builder.baselineValues(86623L) .baselineValues(11L) .baselineValues(666L).build().run(); }