org.apache.kylin.query.schema.OLAPSchemaFactory Java Examples
The following examples show how to use
org.apache.kylin.query.schema.OLAPSchemaFactory.
You can vote up the ones you like or vote down the ones you don't like,
and go to the original project or source file by following the links above each example. You may check out the related API usage on the sidebar.
Example #1
Source File: QueryConnection.java From kylin-on-parquet-v2 with Apache License 2.0 | 6 votes |
public static Connection getConnection(String project) throws SQLException { if (!isRegister) { try { Class<?> aClass = Thread.currentThread().getContextClassLoader() .loadClass("org.apache.calcite.jdbc.Driver"); Driver o = (Driver) aClass.getDeclaredConstructor().newInstance(); DriverManager.registerDriver(o); } catch (ClassNotFoundException | InstantiationException | IllegalAccessException | NoSuchMethodException | InvocationTargetException e) { e.printStackTrace(); } isRegister = true; } File olapTmp = OLAPSchemaFactory.createTempOLAPJson(project, KylinConfig.getInstanceFromEnv()); Properties info = new Properties(); info.putAll(KylinConfig.getInstanceFromEnv().getCalciteExtrasProperties()); // Import calcite props from jdbc client(override the kylin.properties) info.putAll(BackdoorToggles.getJdbcDriverClientCalciteProps()); info.put("model", olapTmp.getAbsolutePath()); info.put("typeSystem", "org.apache.kylin.query.calcite.KylinRelDataTypeSystem"); return DriverManager.getConnection("jdbc:calcite:", info); }
Example #2
Source File: QueryConnection.java From kylin with Apache License 2.0 | 6 votes |
public static Connection getConnection(String project) throws SQLException { if (!isRegister) { try { Class<?> aClass = Thread.currentThread().getContextClassLoader() .loadClass("org.apache.calcite.jdbc.Driver"); Driver o = (Driver) aClass.getDeclaredConstructor().newInstance(); DriverManager.registerDriver(o); } catch (ClassNotFoundException | InstantiationException | IllegalAccessException | NoSuchMethodException | InvocationTargetException e) { e.printStackTrace(); } isRegister = true; } File olapTmp = OLAPSchemaFactory.createTempOLAPJson(project, KylinConfig.getInstanceFromEnv()); Properties info = new Properties(); info.putAll(KylinConfig.getInstanceFromEnv().getCalciteExtrasProperties()); // Import calcite props from jdbc client(override the kylin.properties) info.putAll(BackdoorToggles.getJdbcDriverClientCalciteProps()); info.put("model", olapTmp.getAbsolutePath()); info.put("typeSystem", "org.apache.kylin.query.calcite.KylinRelDataTypeSystem"); return DriverManager.getConnection("jdbc:calcite:", info); }
Example #3
Source File: KylinQueryTest.java From Kylin with Apache License 2.0 | 5 votes |
private static void setUpCubeConn() throws SQLException { // Cube Connection File olapTmp = OLAPSchemaFactory.createTempOLAPJson(ProjectInstance.DEFAULT_PROJECT_NAME, config); Properties props = new Properties(); props.setProperty(OLAPQuery.PROP_SCAN_THRESHOLD, "10000"); cubeConnection = DriverManager.getConnection("jdbc:calcite:model=" + olapTmp.getAbsolutePath(), props); }
Example #4
Source File: BasicService.java From Kylin with Apache License 2.0 | 5 votes |
public DataSource getOLAPDataSource(String project) { project = ProjectInstance.getNormalizedProjectName(project); DataSource ret = olapDataSources.get(project); if (ret == null) { logger.debug("Creating a new data source"); logger.debug("OLAP data source pointing to " + getConfig()); File modelJson = OLAPSchemaFactory.createTempOLAPJson(project, getConfig()); try { List<String> text = Files.readLines(modelJson, Charset.defaultCharset()); logger.debug("The new temp olap json is :"); for (String line : text) logger.debug(line); } catch (IOException e) { e.printStackTrace(); // logging failure is not critical } DriverManagerDataSource ds = new DriverManagerDataSource(); Properties props = new Properties(); props.setProperty(OLAPQuery.PROP_SCAN_THRESHOLD, String.valueOf(KylinConfig.getInstanceFromEnv().getScanThreshold())); ds.setConnectionProperties(props); ds.setDriverClassName("net.hydromatic.optiq.jdbc.Driver"); ds.setUrl("jdbc:calcite:model=" + modelJson.getAbsolutePath()); ret = olapDataSources.putIfAbsent(project, ds); if (ret == null) { ret = ds; } } return ret; }
Example #5
Source File: QueryCli.java From Kylin with Apache License 2.0 | 4 votes |
public static void main(String[] args) throws Exception { Options options = new Options(); options.addOption(OPTION_METADATA); options.addOption(OPTION_SQL); CommandLineParser parser = new GnuParser(); CommandLine commandLine = parser.parse(options, args); KylinConfig config = KylinConfig.createInstanceFromUri(commandLine.getOptionValue(OPTION_METADATA.getOpt())); String sql = commandLine.getOptionValue(OPTION_SQL.getOpt()); Class.forName("net.hydromatic.optiq.jdbc.Driver"); File olapTmp = OLAPSchemaFactory.createTempOLAPJson(null, config); Connection conn = null; Statement stmt = null; ResultSet rs = null; try { conn = DriverManager.getConnection("jdbc:calcite:model=" + olapTmp.getAbsolutePath()); stmt = conn.createStatement(); rs = stmt.executeQuery(sql); int n = 0; ResultSetMetaData meta = rs.getMetaData(); while (rs.next()) { n++; for (int i = 1; i <= meta.getColumnCount(); i++) { System.out.println(n + " - " + meta.getColumnLabel(i) + ":\t" + rs.getObject(i)); } } } finally { if (rs != null) { rs.close(); } if (stmt != null) { stmt.close(); } if (conn != null) { conn.close(); } } }