@Test
public void testUse() throws Exception {
File f = genCSVFile("testUse",
"{\"columns\": [\"f\",\"g\"]}");
String jsonTableName = format("\"${WORKING_PATH}/%s\"", f.getPath());
test("use dfs");
try {
String[] jsonQueries = {
format("select columns from table(%s ('JSON'))", jsonTableName),
format("select columns from table(%s(type => 'JSON'))", jsonTableName),
};
for (String jsonQuery : jsonQueries) {
testWithResult(jsonQuery, listOf("f","g"));
}
testWithResult(format("select length(columns[0]) as columns from table(%s ('JSON'))", jsonTableName), 1);
} finally {
test("use sys");
}
}