@After public void tearDown() { cleanupTestMetadata(); }
@Before public void setup() throws Exception { createTestMetadata(); config = KylinConfig.getInstanceFromEnv(); lookupTable = initLookupTable(); }
@Test public void testScan() throws Exception { List<String> values = new ArrayList<String>(); values.add(millis("2012-01-24")); values.add(millis("2012-12-30")); List<String> results = lookupTable.scan("CAL_DT", values, "YEAR_BEG_DT"); Assert.assertTrue(results.size() > 0); for (String i : results) { System.out.println(i); Assert.assertEquals(millis("2012-01-01"), i); } }
@Test public void testSnapshotOverVolume() throws IOException { KylinConfig cubeConfig = KylinConfig.createKylinConfig(getTestConfig()); cubeConfig.setProperty("kylin.snapshot.max-mb", "0"); String tableName = "DEFAULT.TEST_KYLIN_FACT"; TableDesc tableDesc = TableMetadataManager.getInstance(getTestConfig()).getTableDesc(tableName, "default"); IReadableTable mockTable = new IReadableTable() { @Override SnapshotManager snapshotManager = getSnapshotManager(); try { snapshotManager.buildSnapshot(mockTable, tableDesc, cubeConfig).getResourcePath();
public LookupTable<String> initLookupTable() throws Exception { TableMetadataManager metaMgr = TableMetadataManager.getInstance(config); String tableName = "EDW.TEST_CAL_DT"; String[] pkCols = new String[] { "CAL_DT" }; String snapshotResPath = "/table_snapshot/TEST_CAL_DT.csv/4af48c94-86de-4e22-a4fd-c49b06cbaa4f.snapshot"; SnapshotTable snapshot = getSnapshotManager().getSnapshotTable(snapshotResPath); TableDesc tableDesc = metaMgr.getTableDesc(tableName, "default"); LookupTable<String> lt = new LookupStringTable(tableDesc, pkCols, snapshot); System.out.println(lt); return lt; }
public LookupTable initLookupTable() throws Exception { MetadataManager metaMgr = MetadataManager.getInstance(config); String tableName = "EDW.TEST_CAL_DT"; String[] pkCols = new String[]{"CAL_DT"}; String snapshotResPath = "/table_snapshot/TEST_CAL_DT.csv/4af48c94-86de-4e22-a4fd-c49b06cbaa4f.snapshot"; SnapshotTable snapshot = getSnapshotManager().getSnapshotTable(snapshotResPath); TableDesc tableDesc = metaMgr.getTableDesc(tableName); LookupTable lt = new LookupStringTable(tableDesc, pkCols, snapshot); System.out.println(lt); return lt; }
@Before public void setup() throws Exception { createTestMetadata(); config = KylinConfig.getInstanceFromEnv(); lookupTable = initLookupTable(); }
@After public void tearDown() { cleanupTestMetadata(); }
@Test public void testMapValues() throws Exception { Set<String> values = new HashSet<String>(); values.add(millis("2012-01-24")); values.add(millis("2012-12-30")); Set<String> results = lookupTable.mapValues("CAL_DT", values, "YEAR_BEG_DT"); Assert.assertTrue(results.size() == 1); for (String i : results) { System.out.println(i); Assert.assertEquals(millis("2012-01-01"), i); } }
@Test public void testMapRange() throws Exception { Pair<String, String> results = lookupTable.mapRange("CAL_DT", millis("2012-01-24"), millis("2012-12-30"), "QTR_BEG_DT"); Assert.assertTrue(results != null); System.out.println("The first qtr_beg_dt is " + results.getFirst()); System.out.println("The last qtr_beg_dt is " + results.getSecond()); Assert.assertEquals(millis("2012-01-01"), results.getFirst()); Assert.assertEquals(millis("2012-10-01"), results.getSecond()); }
@Test public void testMapRange2() throws Exception { Pair<String, String> results = lookupTable.mapRange("WEEK_BEG_DT", millis("2013-05-01"), millis("2013-08-01"), "CAL_DT"); System.out.println(DateFormat.formatToDateStr(Long.parseLong(results.getFirst()))); System.out.println(DateFormat.formatToDateStr(Long.parseLong(results.getSecond()))); Assert.assertEquals(millis("2013-05-05"), results.getFirst()); Assert.assertEquals(millis("2013-08-03"), results.getSecond()); }