Alter table rename across dbs doesnt work – alter table db1.tb1 rename to db2.tb2
- is duplicated by
-
ATLAS-648
Alter view rename does not work across databases
-
-
Resolved
{"report":{"fcp":2061.900000035763,"ttfb":195.10000002384186,"pageVisibility":"visible","entityId":12953294,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":16,"apdex":0.5,"journeyId":"0a3c6a84-065a-4dd9-bfc7-e7a6abb42c74","navigationType":0,"readyForUser":2192.199999988079,"redirectCount":0,"resourceLoadedEnd":873.5,"resourceLoadedStart":201.4000000357628,"resourceTiming":[{"duration":191.69999998807907,"initiatorType":"link","name":"https://issues-test.apache.org/jira/s/b62489a2eaac59d9b8a093c1a51d034f-CDN/xd97tr/820010/13pdxe5/49fa3aa3d35a2cc689cbf274e66cc41a/_/download/contextbatch/css/_super/batch.css","startTime":201.4000000357628,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":201.4000000357628,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":393.10000002384186,"responseStart":0,"secureConnectionStart":0},{"duration":191.70000004768372,"initiatorType":"link","name":"https://issues-test.apache.org/jira/s/56490edcf9d54e35149505f78cca6a47-CDN/xd97tr/820010/13pdxe5/72cb823bcc50211a60c1ebe830467cae/_/download/contextbatch/css/jira.browse.project,jira.view.issue,project.issue.navigator,atl.general,atl.global,jira.global,jira.general,-_super/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&richediton=true&slack-enabled=true","startTime":201.69999998807907,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":201.69999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":393.4000000357628,"responseStart":0,"secureConnectionStart":0},{"duration":275.69999998807907,"initiatorType":"script","name":"https://issues-test.apache.org/jira/s/5263129088916436ab9aeb2417075b3f-CDN/xd97tr/820010/13pdxe5/49fa3aa3d35a2cc689cbf274e66cc41a/_/download/contextbatch/js/_super/batch.js?locale=en-UK","startTime":201.80000001192093,"connectEnd":201.80000001192093,"connectStart":201.80000001192093,"domainLookupEnd":201.80000001192093,"domainLookupStart":201.80000001192093,"fetchStart":201.80000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":392.10000002384186,"responseEnd":477.5,"responseStart":416.10000002384186,"secureConnectionStart":201.80000001192093},{"duration":671.5,"initiatorType":"script","name":"https://issues-test.apache.org/jira/s/611c208bd094adb71a6f4f3e7f6fff3d-CDN/xd97tr/820010/13pdxe5/72cb823bcc50211a60c1ebe830467cae/_/download/contextbatch/js/jira.browse.project,jira.view.issue,project.issue.navigator,atl.general,atl.global,jira.global,jira.general,-_super/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en-UK&richediton=true&slack-enabled=true","startTime":202,"connectEnd":420.30000001192093,"connectStart":392.5,"domainLookupEnd":392.5,"domainLookupStart":392.5,"fetchStart":202,"redirectEnd":0,"redirectStart":0,"requestStart":420.80000001192093,"responseEnd":873.5,"responseStart":445,"secureConnectionStart":405.80000001192093},{"duration":235.39999997615814,"initiatorType":"script","name":"https://issues-test.apache.org/jira/s/d41d8cd98f00b204e9800998ecf8427e-CDN/xd97tr/820010/13pdxe5/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":202.10000002384186,"connectEnd":420.4000000357628,"connectStart":392.4000000357628,"domainLookupEnd":392.4000000357628,"domainLookupStart":392.4000000357628,"fetchStart":202.10000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":420.80000001192093,"responseEnd":437.5,"responseStart":436.69999998807907,"secureConnectionStart":405.60000002384186},{"duration":234.19999998807907,"initiatorType":"script","name":"https://issues-test.apache.org/jira/s/d41d8cd98f00b204e9800998ecf8427e-CDN/xd97tr/820010/13pdxe5/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":202.30000001192093,"connectEnd":420.60000002384186,"connectStart":392.80000001192093,"domainLookupEnd":392.80000001192093,"domainLookupStart":392.69999998807907,"fetchStart":202.30000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":420.80000001192093,"responseEnd":436.5,"responseStart":435.5,"secureConnectionStart":406.10000002384186},{"duration":191.5,"initiatorType":"link","name":"https://issues-test.apache.org/jira/s/981f587853769311cda7c3b845131a06-CDN/xd97tr/820010/13pdxe5/cb5a5495a038c0744457f25821ba9ee8/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":202.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":202.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":394,"responseStart":0,"secureConnectionStart":0},{"duration":244,"initiatorType":"script","name":"https://issues-test.apache.org/jira/rest/api/1.0/shortcuts/820010/c8014d201e84f34012505ebcb0ff1649/shortcuts.js?context=issuenavigation&context=issueaction","startTime":202.60000002384186,"connectEnd":430.80000001192093,"connectStart":403.80000001192093,"domainLookupEnd":403.80000001192093,"domainLookupStart":403.80000001192093,"fetchStart":202.60000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":430.80000001192093,"responseEnd":446.60000002384186,"responseStart":445.69999998807907,"secureConnectionStart":416.69999998807907},{"duration":179.69999998807907,"initiatorType":"link","name":"https://issues-test.apache.org/jira/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/xd97tr/820010/13pdxe5/efa42a25652b26dfd802540c024826b3/_/download/contextbatch/css/com.atlassian.jira.projects.sidebar.init,-_super,-jira.view.issue,-project.issue.navigator/batch.css?jira.create.linked.issue=true&richediton=true","startTime":224.30000001192093,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":224.30000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":404,"responseStart":0,"secureConnectionStart":0},{"duration":238.70000004768372,"initiatorType":"script","name":"https://issues-test.apache.org/jira/s/efa8931cd5ac13ed95c56ca8a1dc1967-CDN/xd97tr/820010/13pdxe5/efa42a25652b26dfd802540c024826b3/_/download/contextbatch/js/com.atlassian.jira.projects.sidebar.init,-_super,-jira.view.issue,-project.issue.navigator/batch.js?jira.create.linked.issue=true&locale=en-UK&richediton=true","startTime":224.69999998807907,"connectEnd":434.60000002384186,"connectStart":405.19999998807907,"domainLookupEnd":405.19999998807907,"domainLookupStart":405.19999998807907,"fetchStart":224.69999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":434.60000002384186,"responseEnd":463.4000000357628,"responseStart":450.10000002384186,"secureConnectionStart":419.80000001192093},{"duration":220.89999997615814,"initiatorType":"script","name":"https://issues-test.apache.org/jira/s/d41d8cd98f00b204e9800998ecf8427e-CDN/xd97tr/820010/13pdxe5/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":241.9000000357628,"connectEnd":241.9000000357628,"connectStart":241.9000000357628,"domainLookupEnd":241.9000000357628,"domainLookupStart":241.9000000357628,"fetchStart":241.9000000357628,"redirectEnd":0,"redirectStart":0,"requestStart":437.60000002384186,"responseEnd":462.80000001192093,"responseStart":455.30000001192093,"secureConnectionStart":241.9000000357628},{"duration":381.10000002384186,"initiatorType":"script","name":"https://issues-test.apache.org/jira/s/d41d8cd98f00b204e9800998ecf8427e-CDN/xd97tr/820010/13pdxe5/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":262.5,"connectEnd":262.5,"connectStart":262.5,"domainLookupEnd":262.5,"domainLookupStart":262.5,"fetchStart":262.5,"redirectEnd":0,"redirectStart":0,"requestStart":628.5,"responseEnd":643.6000000238419,"responseStart":642.6999999880791,"secureConnectionStart":262.5},{"duration":364.69999998807907,"initiatorType":"xmlhttprequest","name":"https://issues-test.apache.org/jira/rest/webResources/1.0/resources","startTime":695.4000000357628,"connectEnd":695.4000000357628,"connectStart":695.4000000357628,"domainLookupEnd":695.4000000357628,"domainLookupStart":695.4000000357628,"fetchStart":695.4000000357628,"redirectEnd":0,"redirectStart":0,"requestStart":1041.300000011921,"responseEnd":1060.1000000238419,"responseStart":1059.5,"secureConnectionStart":695.4000000357628},{"duration":458.7999999523163,"initiatorType":"xmlhttprequest","name":"https://issues-test.apache.org/jira/rest/webResources/1.0/resources","startTime":1920.9000000357628,"connectEnd":1920.9000000357628,"connectStart":1920.9000000357628,"domainLookupEnd":1920.9000000357628,"domainLookupStart":1920.9000000357628,"fetchStart":1920.9000000357628,"redirectEnd":0,"redirectStart":0,"requestStart":2344.300000011921,"responseEnd":2379.699999988079,"responseStart":2378.900000035763,"secureConnectionStart":1920.9000000357628}],"fetchStart":0,"domainLookupStart":47,"domainLookupEnd":133,"connectStart":133,"connectEnd":161,"secureConnectionStart":146,"requestStart":161,"responseStart":195,"responseEnd":262,"domLoading":200,"domInteractive":2327,"domContentLoadedEventStart":2327,"domContentLoadedEventEnd":2405,"domComplete":2931,"loadEventStart":2931,"loadEventEnd":2934,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":2278.699999988079},{"name":"bigPipe.sidebar-id.end","time":2279.600000023842},{"name":"bigPipe.activity-panel-pipe-id.start","time":2279.800000011921},{"name":"bigPipe.activity-panel-pipe-id.end","time":2281.600000023842},{"name":"activityTabFullyLoaded","time":2423.800000011921}],"measures":[],"correlationId":"fa265d9ddc0238","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":79,"dbReadsTimeInMs":5,"dbConnsTimeInMs":11,"applicationHash":"ace47f9899e9ee25d7157d59aa17ab06aee30d3d","experiments":[]}}
Changed existing test HiveHookIT.testAlterTableRename to test renames across DBs.
HIveHookIT.testAlterViewRename checks the case within a database.