我正在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/