Hi there,
Flink Version: 1.8.1
JDBC driver: net.snowflake.client.jdbc.SnowflakeDriver
Here is the code snippet:
val rowTypeInfo = new RowTypeInfo(
Array[TypeInformation[_]](
new RowTypeInfo(
Array[TypeInformation[_]](BasicTypeInfo.STRING_TYPE_INFO,
BasicTypeInfo.STRING_TYPE_INFO),
Array[String]("a", "b")
)
),
Array[String]("fieldName")
)
val inputFormat = buildInputFormat(query, rowTypeInfo)
env.createInput(inputFormat)
my snowflake table data looks like this (fieldName has type VARIANT)
fieldName
--------------
{
"a": "1",
"b": "2"
}
I got err msg:
Caused by: java.lang.ClassCastException: java.lang.String cannot be cast to
org.apache.flink.types.Row
Looks like the record I got from snowflake is a string. The error prevents
me from doing something like
sqlQuery("select fieldName.a from table")
Any help is appreciated!
Thanks,
Fanbin