IBM Support

Error when creating a table using Row Format Serde

Troubleshooting


Problem

Unable to create table in BigSQL using Row Format Serde. Table create syntax: CREATE TABLE PROVIDERS (i int, providers string) ROW FORMAT SERDE "org.apache.hadoop.hive.serde2.lazybinary.lazybinarySerDe" STORED AS BINARY SEQUENCEFILE

Symptom

An unexpected token ""org.apache.hadoop.hive.se" was found following
""org.apache.hadoop.hive.se". Expected tokens may include:
"StringLiteral".. SQLCODE=-104, SQLSTATE=42601, DRIVER=3.69.24

[{"Product":{"code":"SSCRJT","label":"IBM Db2 Big SQL"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"--","Platform":[{"code":"PF016","label":"Linux"}],"Version":"Version Independent","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

More support for:
IBM Db2 Big SQL

Software version:
Version Independent

Operating system(s):
Linux

Document number:
298563

Modified date:
08 April 2021

UID

swg22009866

Manage My Notification Subscriptions