37 final SqlStdOperatorTable stdOpTab = SqlStdOperatorTable.instance();
42 MapDUser mdu =
new MapDUser(
"admin",
"passwd",
"catalog", -1);
44 new MapDSchema(
"/home/michael/mapd2/build/data", null, -1, mdu, null);
45 final SchemaPlus rootSchema = Frameworks.createRootSchema(
true);
46 final FrameworkConfig config = Frameworks.newConfigBuilder()
47 .defaultSchema(rootSchema.add(
"omnisci", mapd))
48 .operatorTable(stdOpTab)
51 Planner p = Frameworks.getPlanner(config);
53 SqlNode parseR = null;
55 parseR = p.parse(
"select * from customer where c_custkey = 1.345000 limit 5");
56 }
catch (SqlParseException ex) {
57 Logger.getLogger(tester.class.getName()).log(Level.SEVERE, null, ex);
60 SqlNode validateR = null;
63 }
catch (ValidationException ex) {
64 Logger.getLogger(tester.class.getName()).log(Level.SEVERE, null, ex);
68 relR = p.rel(validateR);
69 }
catch (RelConversionException ex) {
70 Logger.getLogger(tester.class.getName()).log(Level.SEVERE, null, ex);
72 MAPDLOGGER.error(
"Result was " + relR);
73 MAPDLOGGER.error(
"Result project() " + relR.project());
74 MAPDLOGGER.error(
"Result project() " + RelOptUtil.toString(relR.project()));
75 MAPDLOGGER.error(
"Json Version \n" + MapDSerializer.toString(relR.project()));
78 MapDParser mp =
new MapDParser(
"/home/michael/mapd2/build/data", null, -1, null);
82 MapDParserOptions mdpo =
new MapDParserOptions();
83 MAPDLOGGER.error(
"MapDParser result: \n"
85 "select * from customer where c_custkey = 1.345000 limit 5",
88 }
catch (SqlParseException ex) {
89 Logger.getLogger(tester.class.getName()).log(Level.SEVERE, null, ex);
90 }
catch (ValidationException ex) {
91 Logger.getLogger(tester.class.getName()).log(Level.SEVERE, null, ex);
92 }
catch (RelConversionException ex) {
93 Logger.getLogger(tester.class.getName()).log(Level.SEVERE, null, ex);