Hello I usually used pulumi with aws. I have some ...
# aws
r
Hello I usually used pulumi with aws. I have some error. I wrote down error situation. I tried this
Copy code
new 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.
Copy code
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?
b
this error seems to be related to Athena itself, I'd recommend asking the AWS support network for assistance
r
Thank you for your reply. Already it's under investigation in AWS support. However, the survey takes time, so I asked a question here as well. I feel that I made a mistake in using pulumi. Or I think that it cannot be realized with pulumi.