Examples with PhoenixArray org.apache.phoenix.schema.types.PhoenixArray used on opensource projects

Example 31 with PhoenixArray

use of org.apache.phoenix.schema.types.PhoenixArray in project phoenix by apache.

the class ArrayPrependFunctionIT method testArrayPrependFunctionNulls2.

@Test
public void testArrayPrependFunctionNulls2() throws Exception {
    Connection conn = DriverManager.getConnection(getUrl());
    String[] s = new String[] { "1", "2" };
    String tableName = generateUniqueName();
    initTableWithVarArray(conn, tableName, "VARCHAR", s, null);
    String[] s2 = new String[] { null, "1", "2" };
    PhoenixArray array2 = (PhoenixArray) conn.createArrayOf("VARCHAR", s2);
    conn = DriverManager.getConnection(getUrl());
    ResultSet rs;
    rs = conn.createStatement().executeQuery("SELECT ARRAY_PREPEND(b,a) FROM " + tableName + " WHERE k = 'a'");
    assertTrue(rs.next());
    assertEquals(array2, rs.getArray(1));
}

Example 32 with PhoenixArray

use of org.apache.phoenix.schema.types.PhoenixArray in project phoenix by apache.

the class StringToArrayFunctionIT method testStringToArrayFunction5.

@Test
public void testStringToArrayFunction5() throws Exception {
    Connection conn = DriverManager.getConnection(getUrl());
    ResultSet rs;
    rs = conn.createStatement().executeQuery("SELECT STRING_TO_ARRAY(string2, delimiter2) FROM " + tableName + " WHERE region_name = 'SF Bay Area'");
    assertTrue(rs.next());
    PhoenixArray expected = new PhoenixArray(PVarchar.INSTANCE, new Object[] { "1", "2", "3", "4" });
    assertEquals(expected, rs.getArray(1));
    assertFalse(rs.next());
}

Example 33 with PhoenixArray

use of org.apache.phoenix.schema.types.PhoenixArray in project phoenix by apache.

the class StringToArrayFunctionIT method testStringToArrayFunction3.

@Test
public void testStringToArrayFunction3() throws Exception {
    Connection conn = DriverManager.getConnection(getUrl());
    ResultSet rs;
    rs = conn.createStatement().executeQuery("SELECT STRING_TO_ARRAY(string1, delimiter1, 'a') FROM " + tableName + " WHERE region_name = 'SF Bay Area'");
    assertTrue(rs.next());
    PhoenixArray expected = new PhoenixArray(PVarchar.INSTANCE, new Object[] { null, "b", "c", "d" });
    assertEquals(expected, rs.getArray(1));
    assertFalse(rs.next());
}

Example 34 with PhoenixArray

use of org.apache.phoenix.schema.types.PhoenixArray in project phoenix by apache.

the class StringToArrayFunctionIT method testStringToArrayFunction4.

@Test
public void testStringToArrayFunction4() throws Exception {
    Connection conn = DriverManager.getConnection(getUrl());
    ResultSet rs;
    rs = conn.createStatement().executeQuery("SELECT STRING_TO_ARRAY(string1, delimiter1, 'd') FROM " + tableName + " WHERE region_name = 'SF Bay Area'");
    assertTrue(rs.next());
    PhoenixArray expected = new PhoenixArray(PVarchar.INSTANCE, new Object[] { "a", "b", "c", null });
    assertEquals(expected, rs.getArray(1));
    assertFalse(rs.next());
}

Example 35 with PhoenixArray

use of org.apache.phoenix.schema.types.PhoenixArray in project phoenix by apache.

the class RegexpSplitFunctionTest method evalExp.

private String[] evalExp(Expression exp) throws SQLException {
    ImmutableBytesWritable ptr = new ImmutableBytesWritable();
    boolean eval = exp.evaluate(null, ptr);
    assertTrue(eval);
    PhoenixArray evalRes = (PhoenixArray) exp.getDataType().toObject(ptr);
    String[] res = (String[]) evalRes.getArray();
    return res;
}