首页 > 其他分享 >REMOVE PARTITIONING

REMOVE PARTITIONING

时间:2023-11-01 17:13:49浏览次数:25  
标签:PARTITIONING 分区 REMOVE 分区表 TABLE ALTER

本文档介绍了删除分区表的分区结构,并转化成单表,且不丢失数据的方法。

语法

ALTER TABLE ... REMOVE PARTITIONING命令用于删除分区和子分区表的分区结构,并转化成单表,且不丢失数据:  
ALTER TABLE table_name REMOVE PARTITIONING

示例

删除sales_range_list表中所有的分区结构:  
ALTER TABLE sales_range_list REMOVE PARTITIONING;

标签:PARTITIONING,分区,REMOVE,分区表,TABLE,ALTER
From: https://www.cnblogs.com/zhangq/p/17803554.html

相关文章

  • ConcurrentModificationException异常,for循环遍历时候, add或者remove减少集合的元素时
    ConcurrentModificationException异常一:ConcurrentModificationException异常:当方法检测到对象的并发修改,但不允许这种修改时,抛出此异常。二:遍历list集合时删除元素出现的异常publicstaticvoidmain(String[]args){ArrayList<String>list=newArrayList<String>();......
  • [909] Remove duplicated rows based on multiple columns in Pandas
    InaPandasDataFrame,youcanremoveduplicatedrowsbasedonmultiplecolumnsusingthedrop_duplicates()method.Here'showyoucandoit:importpandasaspd#SampleDataFramedata={'A':[1,2,3,2,1],'B':[�......
  • 【刷题笔记】80. Remove Duplicates from Sorted Array II
    题目Givenasortedarraynums,removetheduplicatesin-placesuchthatduplicatesappearedatmosttwiceandreturnthenewlength.Donotallocateextraspaceforanotherarray,youmustdothisbymodifyingtheinputarrayin-placewithO(1)extramemor......
  • Go - Remove values from a slice
    Totakeoutthefirstelementoftheslice:numbers:=[]int{3,14,159,26,53,58}numbers=numbers[1:]//removeelement0To takeoutthelastelementoftheslice:numbers:=[]int{3,14,159,2......
  • Remove Old ST03N Data after System Refresh(转)
    SymptomAfterasystemrefresh/systemcopy,thetransactioncodeST03Nisshowingtheolddatafromthesourcesystem.Solution1.RefertoSAPNote1179929ThedatafromothersystemscanbedeletedfromthetablesSWNCMONIandSWNCMONIINDEXusingthefu......
  • uniCloud-传统方式操作数据库-remove
    collection.doc(_id).remove()collection.where().remove()删除之前一定要备份数据库表,删除时一定要写正确查询条件.云函数代码'usestrict';exports.main=async(event,context)=>{ //通过云函数操作数据库,删除指定记录 constdb=uniCloud.database() cons......
  • UserWarning: The parameter 'pretrained' is deprecated since 0.13 and may be remo
    从torchvision0.13开始,加载预训练模型函数的参数从pretrained=True改为weights=预训练模型参数版本。且旧版本的写法将在未来的torchvision0.15版本中被Deprecated。fromtorchvisionimportmodels#旧版本的写法,将在未来的torchvision0.15版本中被Deprecatedmod......
  • 直接Remove集合中的元素会导致"集合已修改"的错误
    varF_JNXM_CFSplitEntry=DataEntity["F_JNXM_CFSplitEntry"]asDynamicObjectCollection;//拆单明细varmatchEntrys=F_JNXM_CFSplitEntry.Where(p=>p["F_JNXM_MaterialCategory"].GetStringJNXM().Contains("五金"));//过滤五金分录行......
  • js removeRepeat 数组去重
    //数组不去重_this.incompleteData.map(e=>e.order_id).join(',')//数组去重varorder_ids=_this.incompleteData.map(e=>e.order_id).removeRepeat().join(','); ......
  • Three ways to conditionally remove variables in a dataset
    Method1:proccontentsdata=carsshortout=outds00;run;dataoutds(keep=name);setoutds00;vnam=substr(name,1,1);ifvnamne"M"thenoutput;run;proctransposedata=outdsout=outds01(drop=_name__label_);idname;run;dataoutds02(drop=......