36 final SqlStdOperatorTable stdOpTab = SqlStdOperatorTable.instance();
41 MapDUser mdu =
new MapDUser(
"admin",
"passwd",
"catalog", -1);
43 new MapDSchema(
"/home/michael/mapd2/build/data", null, -1, mdu, null);
44 final SchemaPlus rootSchema = Frameworks.createRootSchema(
true);
45 final FrameworkConfig config = Frameworks.newConfigBuilder()
46 .defaultSchema(rootSchema.add(
"omnisci", mapd))
47 .operatorTable(stdOpTab)
50 Planner p = Frameworks.getPlanner(config);
52 SqlNode parseR = null;
54 parseR = p.parse(
"select * from customer where c_custkey = 1.345000 limit 5");
55 }
catch (SqlParseException ex) {
56 Logger.getLogger(tester.class.getName()).log(Level.SEVERE, null, ex);
59 SqlNode validateR = null;
62 }
catch (ValidationException ex) {
63 Logger.getLogger(tester.class.getName()).log(Level.SEVERE, null, ex);
67 relR = p.rel(validateR);
68 }
catch (RelConversionException ex) {
69 Logger.getLogger(tester.class.getName()).log(Level.SEVERE, null, ex);
71 MAPDLOGGER.error(
"Result was " + relR);
72 MAPDLOGGER.error(
"Result project() " + relR.project());
73 MAPDLOGGER.error(
"Result project() " + RelOptUtil.toString(relR.project()));
74 MAPDLOGGER.error(
"Json Version \n" + MapDSerializer.toString(relR.project()));
77 MapDParser mp =
new MapDParser(
"/home/michael/mapd2/build/data", null, -1, null);
81 MapDParserOptions mdpo =
new MapDParserOptions();
82 MAPDLOGGER.error(
"MapDParser result: \n"
84 "select * from customer where c_custkey = 1.345000 limit 5", mdpo));
85 }
catch (SqlParseException ex) {
86 Logger.getLogger(tester.class.getName()).log(Level.SEVERE, null, ex);
87 }
catch (ValidationException ex) {
88 Logger.getLogger(tester.class.getName()).log(Level.SEVERE, null, ex);
89 }
catch (RelConversionException ex) {
90 Logger.getLogger(tester.class.getName()).log(Level.SEVERE, null, ex);