rhythmic-photographer-84959
12/28/2021, 3:53 AMnew aws.glue.CatalogTable(`${databaseName}.${tableName}.view`, {
databaseName: databaseName,
name: `${tableName}`,
tableType: 'VIRTUAL_VIEW',
parameters: {
comment: 'Presto View',
presto_view: 'true',
},
retention: 0,
viewExpandedText: '/* Presto View */',
viewOriginalText: '/* Presto View: eyJvcmlnaW5hbFNxbCI6IlNFTEVDVFxuICBpZFxuLCBwbGF0Zm9ybV9yb29tX2lkXG4sIHBsYXRmb3JtX3VzZXJfaWRcbiwgZXZlbnRfdHlwZVxuLCByZWNlaXZlZFxuLCBDQVNUKFJPVyAoXCJqc29uX2V4dHJhY3Rfc2NhbGFyXCIoYm9keSwgJyQucGxhdGZvcm0nKSwgUk9XIChcImpzb25fZXh0cmFjdF9zY2FsYXJcIihib2R5LCAnJC5wYXJhbXMuYWNjZXNzVG9rZW4nKSwgXCJqc29uX2V4dHJhY3Rfc2NhbGFyXCIoYm9keSwgJyQucGFyYW1zLmNoYW5uZWxTZWNyZXQnKSwgXCJqc29uX2V4dHJhY3Rfc2NhbGFyXCIoYm9keSwgJyQucGFyYW1zLnVzZVVybFNob3J0ZW5lcicpKSwgUk9XIChcImpzb25fZXh0cmFjdF9zY2FsYXJcIihib2R5LCAnJC51c2VyLmhhc2hlZFVzZXJJZCcpLCBcImpzb25fZXh0cmFjdF9zY2FsYXJcIihib2R5LCAnJC51c2VyLnVzZXJJZCcpLCBcImpzb25fZXh0cmFjdF9zY2FsYXJcIihib2R5LCAnJC51c2VyLmFwcElkJyksIFwianNvbl9leHRyYWN0X3NjYWxhclwiKGJvZHksICckLnVzZXIuY2xpZW50SWQnKSwgXCJqc29uX2V4dHJhY3Rfc2NhbGFyXCIoYm9keSwgJyQudXNlci50eXBlJyksIFJPVyAoXCJqc29uX2V4dHJhY3Rfc2NhbGFyXCIoYm9keSwgJyQudXNlci5wcm9maWxlLnBpY3R1cmVVUkwnKSwgXCJqc29uX2V4dHJhY3Rfc2NhbGFyXCIoYm9keSwgJyQudXNlci5wcm9maWxlLnVuaXF1ZUlEJyksIFwianNvbl9leHRyYWN0X3NjYWxhclwiKGJvZHksICckLnVzZXIucHJvZmlsZS5uYW1lJykpKSwgUk9XIChST1cgKFwianNvbl9leHRyYWN0X3NjYWxhclwiKGJvZHksICckLm1lc3NhZ2UuaW1hZ2UucHJldmlld0ltYWdlVXJsJyksIFwianNvbl9leHRyYWN0X3NjYWxhclwiKGJvZHksICckLm1lc3NhZ2UuaW1hZ2Uub3JpZ2luYWxDb250ZW50VXJsJyksIFwianNvbl9leHRyYWN0X3NjYWxhclwiKGJvZHksICckLm1lc3NhZ2UuaW1hZ2UudHlwZScpKSwgUk9XIChcImpzb25fZXh0cmFjdF9zY2FsYXJcIihib2R5LCAnJC5tZXNzYWdlLnRleHQudGV4dCcpLCBcImpzb25fZXh0cmFjdF9zY2FsYXJcIihib2R5LCAnJC5tZXNzYWdlLnRleHQudHlwZScpKSwgUk9XIChcImpzb25fZXh0cmFjdF9zY2FsYXJcIihib2R5LCAnJC5tZXNzYWdlLnZpZGVvLnByZXZpZXdJbWFnZVVybCcpLCBcImpzb25fZXh0cmFjdF9zY2FsYXJcIihib2R5LCAnJC5tZXNzYWdlLnZpZGVvLm9yaWdpbmFsQ29udGVudFVybCcpLCBcImpzb25fZXh0cmFjdF9zY2FsYXJcIihib2R5LCAnJC5tZXNzYWdlLnZpZGVvLnR5cGUnKSkpLCBcImpzb25fZXh0cmFjdF9zY2FsYXJcIihib2R5LCAnJC50eXBlJyksIFwianNvbl9leHRyYWN0X3NjYWxhclwiKGJvZHksICckLnRpbWVzdGFtcCcpKSBBUyByb3cocGxhdGZvcm0gdmFyY2hhcixwYXJhbXMgcm93KGFjY2Vzc3Rva2VuIHZhcmNoYXIsY2hhbm5lbHNlY3JldCB2YXJjaGFyLHVzZXVybHNob3J0ZW5lciB2YXJjaGFyKSx1c2VyIHJvdyhoYXNoZWR1c2VyaWQgdmFyY2hhcix1c2VyaWQgdmFyY2hhcixhcHBpZCB2YXJjaGFyLGNsaWVudGlkIHZhcmNoYXIsdHlwZSB2YXJjaGFyLHByb2ZpbGUgcm93KHBpY3R1cmV1cmwgdmFyY2hhcix1bmlxdWVpZCB2YXJjaGFyLG5hbWUgdmFyY2hhcikpLG1lc3NhZ2Ugcm93KGltYWdlIHJvdyhwcmV2aWV3aW1hZ2V1cmwgdmFyY2hhcixvcmlnaW5hbGNvbnRlbnR1cmwgdmFyY2hhcix0eXBlIHZhcmNoYXIpLHRleHQgcm93KHRleHQgdmFyY2hhcix0eXBlIHZhcmNoYXIpLHZpZGVvIHJvdyhwcmV2aWV3aW1hZ2V1cmwgdmFyY2hhcixvcmlnaW5hbGNvbnRlbnR1cmwgdmFyY2hhcix0eXBlIHZhcmNoYXIpKSx0eXBlIHZhcmNoYXIsXCJ0aW1lc3RhbXBcIiBpbnRlZ2VyKSkgYm9keVxuLCAoQ0FTRSBXSEVOIChcImxlbmd0aFwiKFwidGltZXN0YW1wXCIpID0gMjIpIFRIRU4gXCJkYXRlX2Zvcm1hdFwiKFwiZGF0ZV9wYXJzZVwiKFwiY29uY2F0XCIoXCJ0aW1lc3RhbXBcIiwgJzAwJyksICclWS0lbS0lZCAlSDolaTolcyswMDAwJykgQVQgVElNRSBaT05FICdBc2lhL1Rva3lvJywgJyVZLSVtLSVkICVIOiVpOiVzLiVmICswOTAwJykgRUxTRSBcImRhdGVfZm9ybWF0XCIoXCJkYXRlX3BhcnNlXCIoXCJjb25jYXRcIihcInRpbWVzdGFtcFwiLCAnMDAnKSwgJyVZLSVtLSVkICVIOiVpOiVzLiVmKzAwMDAnKSBBVCBUSU1FIFpPTkUgJ0FzaWEvVG9reW8nLCAnJVktJW0tJWQgJUg6JWk6JXMuJWYgKzA5MDAnKSBFTkQpIFwidGltZXN0YW1wXCJcbiwgQ0FTVChST1cgKFwianNvbl9leHRyYWN0X3NjYWxhclwiKG5lcl9yZXN1bHRzLCAnJC5lbW9qaScpLCBBUlJBWVtST1coXCJqc29uX2V4dHJhY3Rfc2NhbGFyXCIobmVyX3Jlc3VsdHMsICckLm5lclswXS5sYWJlbCcpLCBcImpzb25fZXh0cmFjdF9zY2FsYXJcIihuZXJfcmVzdWx0cywgJyQubmVyWzBdLnRleHQnKSwgXCJqc29uX2V4dHJhY3Rfc2NhbGFyXCIobmVyX3Jlc3VsdHMsICckLm5lclswXS5lbmQnKSwgXCJqc29uX2V4dHJhY3Rfc2NhbGFyXCIobmVyX3Jlc3VsdHMsICckLm5lclswXS5zdGFydCcpKV0sIFwianNvbl9leHRyYWN0X3NjYWxhclwiKG5lcl9yZXN1bHRzLCAnJC5kaWFsb2cnKSkgQVMgcm93KGVtb2ppIHZhcmNoYXIsbmVyIGFycmF5KHJvdyhsYWJlbCB2YXJjaGFyLHRleHQgdmFyY2hhcixcImVuZFwiIGludGVnZXIsc3RhcnQgaW50ZWdlcikpLGRpYWxvZyB2YXJjaGFyKSkgbmVyX3Jlc3VsdHNcbiwgbmVyX3N0YXR1c1xuLCBzdWdnZXN0X3N0YXR1c1xuLCBcImRhdGVfZm9ybWF0XCIoXCJkYXRlX3BhcnNlXCIoXCJjb25jYXRcIihjcmVhdGVkX2F0LCAnMDAnKSwgJyVZLSVtLSVkICVIOiVpOiVzLiVmKzAwMDAnKSBBVCBUSU1FIFpPTkUgJ0FzaWEvVG9reW8nLCAnJVktJW0tJWQgJUg6JWk6JXMuJWYgKzA5MDAnKSBjcmVhdGVkX2F0XG4sIFwiZGF0ZV9mb3JtYXRcIihcImRhdGVfcGFyc2VcIihcImNvbmNhdFwiKHVwZGF0ZWRfYXQsICcwMCcpLCAnJVktJW0tJWQgJUg6JWk6JXMuJWYrMDAwMCcpIEFUIFRJTUUgWk9ORSAnQXNpYS9Ub2t5bycsICclWS0lbS0lZCAlSDolaTolcy4lZiArMDkwMCcpIHVwZGF0ZWRfYXRcbiwgY29tcGxldGVkXG4sIGRlbGV0ZWRcbkZST01cbiAgY2hhdF9wb3N0Z3Jlcy5yZHNfZXhwb3J0ZWRfcGxhdGZvcm1fZXZlbnRzXG4iLCJjYXRhbG9nIjoiYXdzZGF0YWNhdGFsb2ciLCJzY2hlbWEiOiJjaGF0X3Bvc3RncmVzIiwiY29sdW1ucyI6W3sibmFtZSI6ImlkIiwidHlwZSI6ImludGVnZXIifSx7Im5hbWUiOiJwbGF0Zm9ybV9yb29tX2lkIiwidHlwZSI6ImludGVnZXIifSx7Im5hbWUiOiJwbGF0Zm9ybV91c2VyX2lkIiwidHlwZSI6ImludGVnZXIifSx7Im5hbWUiOiJldmVudF90eXBlIiwidHlwZSI6InZhcmNoYXIifSx7Im5hbWUiOiJyZWNlaXZlZCIsInR5cGUiOiJib29sZWFuIn0seyJuYW1lIjoiYm9keSIsInR5cGUiOiJyb3coXCJwbGF0Zm9ybVwiIHZhcmNoYXIsXCJwYXJhbXNcIiByb3coXCJhY2Nlc3N0b2tlblwiIHZhcmNoYXIsXCJjaGFubmVsc2VjcmV0XCIgdmFyY2hhcixcInVzZXVybHNob3J0ZW5lclwiIHZhcmNoYXIpLFwidXNlclwiIHJvdyhcImhhc2hlZHVzZXJpZFwiIHZhcmNoYXIsXCJ1c2VyaWRcIiB2YXJjaGFyLFwiYXBwaWRcIiB2YXJjaGFyLFwiY2xpZW50aWRcIiB2YXJjaGFyLFwidHlwZVwiIHZhcmNoYXIsXCJwcm9maWxlXCIgcm93KFwicGljdHVyZXVybFwiIHZhcmNoYXIsXCJ1bmlxdWVpZFwiIHZhcmNoYXIsXCJuYW1lXCIgdmFyY2hhcikpLFwibWVzc2FnZVwiIHJvdyhcImltYWdlXCIgcm93KFwicHJldmlld2ltYWdldXJsXCIgdmFyY2hhcixcIm9yaWdpbmFsY29udGVudHVybFwiIHZhcmNoYXIsXCJ0eXBlXCIgdmFyY2hhciksXCJ0ZXh0XCIgcm93KFwidGV4dFwiIHZhcmNoYXIsXCJ0eXBlXCIgdmFyY2hhciksXCJ2aWRlb1wiIHJvdyhcInByZXZpZXdpbWFnZXVybFwiIHZhcmNoYXIsXCJvcmlnaW5hbGNvbnRlbnR1cmxcIiB2YXJjaGFyLFwidHlwZVwiIHZhcmNoYXIpKSxcInR5cGVcIiB2YXJjaGFyLFwidGltZXN0YW1wXCIgaW50ZWdlcikifSx7Im5hbWUiOiJ0aW1lc3RhbXAiLCJ0eXBlIjoidmFyY2hhciJ9LHsibmFtZSI6Im5lcl9yZXN1bHRzIiwidHlwZSI6InJvdyhcImVtb2ppXCIgdmFyY2hhcixcIm5lclwiIGFycmF5KHJvdyhcImxhYmVsXCIgdmFyY2hhcixcInRleHRcIiB2YXJjaGFyLFwiZW5kXCIgaW50ZWdlcixcInN0YXJ0XCIgaW50ZWdlcikpLFwiZGlhbG9nXCIgdmFyY2hhcikifSx7Im5hbWUiOiJuZXJfc3RhdHVzIiwidHlwZSI6ImludGVnZXIifSx7Im5hbWUiOiJzdWdnZXN0X3N0YXR1cyIsInR5cGUiOiJpbnRlZ2VyIn0seyJuYW1lIjoiY3JlYXRlZF9hdCIsInR5cGUiOiJ2YXJjaGFyIn0seyJuYW1lIjoidXBkYXRlZF9hdCIsInR5cGUiOiJ2YXJjaGFyIn0seyJuYW1lIjoiY29tcGxldGVkIiwidHlwZSI6ImJvb2xlYW4ifSx7Im5hbWUiOiJkZWxldGVkIiwidHlwZSI6ImludGVnZXIifV19 */',
storageDescriptor: {
parameters: {},
compressed: false,
numberOfBuckets: 0,
storedAsSubDirectories: false,
serDeInfo: {
parameters: {},
},
columns: [
{
name: 'id',
type: 'int'
},
{
name: 'platform_room_id',
type: 'int'
},
{
name: 'platform_user_id',
type: 'int',
},
{
name: 'event_type',
type: 'string',
},
{
name: 'received',
type: 'boolean',
},
{
name: 'body',
type: 'struct<platform:string,params:struct<accesstoken:string,channelsecret:string,useurlshortener:string>,user:struct<hasheduserid:string,userid:string,appid:string,clientid:string,type:string,profile:struct<pictureurl:string,uniqueid:string,name:string>>,message:struct<image:struct<previewimageurl:string,originalcontenturl:string,type:string>,text:struct<text:string,type:string>,video:struct<previewimageurl:string,originalcontenturl:string,type:string>>,type:string,timestamp:int>'
},
{
name: 'timestamp',
type: 'string'
},
{
name: 'ner_results',
type: 'struct<emoji:string,ner:array<struct<label:string,text:string,end:int,start:int>>,dialog:string>'
},
{
name: 'ner_status',
type: 'int'
},
{
name: 'suggest_status',
type: 'int'
},
{
name: 'created_at',
type: 'string'
},
{
name: 'updated_at',
type: 'string'
},
{
name: 'completed',
type: 'boolean'
},
{
name: 'deleted',
type: 'int'
},
],
},
}
then I tried SQL on athena.
returned error like this.
HIVE_METASTORE_ERROR: Required Table SerDe information is not populated. (Service: null; Status Code: 0; Error Code: null; Request ID: null; Proxy: null)
How should I do resolve error?billowy-army-68599
12/28/2021, 11:14 AMrhythmic-photographer-84959
12/28/2021, 11:36 AM