我正在Cassandra 2.1中尝试UDT,并在InvalidTypeExeception中挣扎。

我将表设置为:

 session.execute("CREATE TYPE mykeyspace.address (" +
                    "  street text," +
                    "  city text," +
                    "  zip_code int," +
                    "  phones set<text>" +
                    ");"
    );
    session.execute("CREATE TYPE mykeyspace.fullname (" +
                    "  firstname text," +
                    "  lastname text" +
                    ");"
    );
    session.execute(
            "CREATE TABLE mykeyspace.users (" +
                    "  id uuid PRIMARY KEY," +
                    "  name frozen <fullname>," +
                    "  direct_reports set<frozen <fullname>>," +
                    "  addresses map<text, frozen <address>>" +
                    ");  ");


然后运行以下内容作为测试:

PreparedStatement statement = session.prepare("INSERT INTO mykeyspace.users (id, name, addresses) VALUES (?, ?, ?);");

UserType fullNameType = session.getCluster().getMetadata().getKeyspace("mykeyspace").getUserType("fullname");
UserType addresType = session.getCluster().getMetadata().getKeyspace("mykeyspace").getUserType("address");

BoundStatement boundStatement = new BoundStatement(statement);

UUID uuid = UUID.randomUUID();

UDTValue name = fullNameType.newValue().setString("firstname", "john").setString("lastname", "smith");


UDTValue address = addresType.newValue()
        .setString("street", "1 long st")
        .setString("city", "sydney")
        .setInt("zip_code", 2000)
        .setSet("phones",ImmutableSet.of("123", "456", "789")); // ERROR THROWN HERE

Map<String, UDTValue> addresses = new HashMap<String, UDTValue>();
addresses.put("home", address);
session.execute(boundStatement.bind(
        uuid,
        name,
        addresses
));


我收到针对.setSet(“ phones ......)行的以下错误:

Exception in thread "main" com.datastax.driver.core.exceptions.InvalidTypeException:
Column phones is of type 'org.apache.cassandra.db.marshal.FrozenType(org.apache.cassandra.db.marshal.SetType(org.apache.cassandra.db.marshal.UTF8Type))', cannot set to a set


只是对我做错了什么以及我在哪里缺少什么感到困惑,我确定这是显而易见的,但无法弄清楚...

谢谢!

最佳答案

那将是驱动程序中的错误。如果已确保使用的是驱动程序的最新发行版(以确保尚未修复),请在java driver jira上报告此情况。

关于java - Cassandra UDT嵌套集InvalidTypeExeception,我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/28573825/

10-10 14:04