Examples with StringTable com.axibase.tsd.api.model.sql.StringTable used on opensource projects

Example 31 with StringTable

use of com.axibase.tsd.api.model.sql.StringTable in project atsd-api-test by axibase.

the class GroupByDatetimeTest method testGroupByDatetimeSyntax.

@Issue("3102")
@Test
public void testGroupByDatetimeSyntax() {
    String sqlQuery = String.format("SELECT datetime , entity, value FROM \"%s\" %nGROUP BY datetime, entity, value", TEST_METRIC_NAME);
    StringTable resultTable = queryResponse(sqlQuery).readEntity(StringTable.class);
    List<List<String>> expectedRows = Arrays.asList(Arrays.asList("2016-06-19T11:00:00.500Z", TESTS_ENTITY1_NAME, "0.0"), Arrays.asList("2016-06-19T11:00:00.500Z", TESTS_ENTITY2_NAME, "0.0"), Arrays.asList("2016-06-19T11:00:00.500Z", TESTS_ENTITY3_NAME, "0.0"), Arrays.asList("2016-06-19T11:00:01.500Z", TESTS_ENTITY1_NAME, "1.0"), Arrays.asList("2016-06-19T11:00:01.500Z", TESTS_ENTITY2_NAME, "1.0"), Arrays.asList("2016-06-19T11:00:02.500Z", TESTS_ENTITY1_NAME, "2.0"));
    assertTableRowsExist(expectedRows, resultTable);
}

Example 32 with StringTable

use of com.axibase.tsd.api.model.sql.StringTable in project atsd-api-test by axibase.

the class CompactedLimitTest method testLimitOnCompactedColumnFamily.

@Issue("4947")
@Test(description = "Test if limit returns requested number of records " + "after performing compaction")
public void testLimitOnCompactedColumnFamily() {
    String sqlQuery = String.format("SELECT * FROM \"%s\" " + "WHERE datetime >= '2018-01-01T00:00:00.000Z' " + "ORDER BY time DESC " + "LIMIT %d", METRIC_NAME, SAMPLE_LIMIT);
    StringTable result = queryTable(sqlQuery);
    int resultSize = result.getRows().size();
    assertEquals(resultSize, SAMPLE_LIMIT, "Wrong limit result after compaction");
}

Example 33 with StringTable

use of com.axibase.tsd.api.model.sql.StringTable in project atsd-api-test by axibase.

the class SqlOrderByColumnIndexTest method test231Order.

@Issue("3191")
@Test
public void test231Order() {
    String sqlQuery = String.format("SELECT entity, value, datetime FROM \"%s\" %nORDER BY 2,3,1", TEST_METRIC_NAME);
    StringTable resultTable = queryResponse(sqlQuery).readEntity(StringTable.class);
    List<List<String>> expectedRows = Arrays.asList(Arrays.asList(TEST_ENTITY2_NAME, "1.0", "2016-06-19T11:00:05.000Z"), Arrays.asList(TEST_ENTITY1_NAME, "2.0", "2016-06-19T11:00:01.000Z"), Arrays.asList(TEST_ENTITY2_NAME, "3.0", "2016-06-19T11:00:04.000Z"), Arrays.asList(TEST_ENTITY1_NAME, "4.0", "2016-06-19T11:00:02.000Z"), Arrays.asList(TEST_ENTITY2_NAME, "5.0", "2016-06-19T11:00:06.000Z"), Arrays.asList(TEST_ENTITY1_NAME, "6.0", "2016-06-19T11:00:00.000Z"));
    assertTableRowsExist(expectedRows, resultTable);
}

Example 34 with StringTable

use of com.axibase.tsd.api.model.sql.StringTable in project atsd-api-test by axibase.

the class SqlOrderByColumnIndexTest method test312Order.

@Issue("3191")
@Test
public void test312Order() {
    String sqlQuery = String.format("SELECT entity, value, datetime FROM \"%s\" %nORDER BY 3,1,2", TEST_METRIC_NAME);
    StringTable resultTable = queryResponse(sqlQuery).readEntity(StringTable.class);
    List<List<String>> expectedRows = Arrays.asList(Arrays.asList(TEST_ENTITY1_NAME, "6.0", "2016-06-19T11:00:00.000Z"), Arrays.asList(TEST_ENTITY1_NAME, "2.0", "2016-06-19T11:00:01.000Z"), Arrays.asList(TEST_ENTITY1_NAME, "4.0", "2016-06-19T11:00:02.000Z"), Arrays.asList(TEST_ENTITY2_NAME, "3.0", "2016-06-19T11:00:04.000Z"), Arrays.asList(TEST_ENTITY2_NAME, "1.0", "2016-06-19T11:00:05.000Z"), Arrays.asList(TEST_ENTITY2_NAME, "5.0", "2016-06-19T11:00:06.000Z"));
    assertTableRowsExist(expectedRows, resultTable);
}

Example 35 with StringTable

use of com.axibase.tsd.api.model.sql.StringTable in project atsd-api-test by axibase.

the class SqlOrderByColumnIndexTest method test321Order.

@Issue("3191")
@Test
public void test321Order() {
    String sqlQuery = String.format("SELECT entity, value, datetime FROM \"%s\" %nORDER BY 3,2,1", TEST_METRIC_NAME);
    StringTable resultTable = queryResponse(sqlQuery).readEntity(StringTable.class);
    List<List<String>> expectedRows = Arrays.asList(Arrays.asList(TEST_ENTITY1_NAME, "6.0", "2016-06-19T11:00:00.000Z"), Arrays.asList(TEST_ENTITY1_NAME, "2.0", "2016-06-19T11:00:01.000Z"), Arrays.asList(TEST_ENTITY1_NAME, "4.0", "2016-06-19T11:00:02.000Z"), Arrays.asList(TEST_ENTITY2_NAME, "3.0", "2016-06-19T11:00:04.000Z"), Arrays.asList(TEST_ENTITY2_NAME, "1.0", "2016-06-19T11:00:05.000Z"), Arrays.asList(TEST_ENTITY2_NAME, "5.0", "2016-06-19T11:00:06.000Z"));
    assertTableRowsExist(expectedRows, resultTable);
}