D*********Y
发帖数: 3382 | 1 我又table A，variable x， table B， variable y
俩table 都很巨大。
现在我想merge A 和 B
条件是，对于每个x，我要merge到和它差距最小的y。
table B的observation可以和多个table A的observation merge。如果merge最
efficient呢？
笨办法我也会几个，但是太笨。
谢谢！ |
|
|
w*******y
发帖数: 60932 | 3 Target.com:
http://target.com
has the Mega Build'n Go Table:
http://www.target.com/p/Mega-Build-n-Go-Table/-/A-11234577
on sale ONLINE for $19.99, regularly $44.99. Use your REDcard to save 5%
and get free shipping.
"Your child will spend hours of playtime with the Build 'n Go Table by Mega
Bloks. This brightly colored table can stimulate your youngster's
imagination while he or she builds fun scenes out of stickers, figurines, a
car and 20 colorful blocks. This piece also folds flat for ea... 阅读全帖 |
|
w***w
发帖数: 6301 | 4 Atlantic City’s Trump Plaza Casino has agreed to test 12 automated poker
tables for PokerTek, Inc., making it the first casino to have the dealerless
tables in the stake of New Jersey.
The tables have already been implemented at places like the Mohegan Sun in
Connecticut and
Canada’s Casino de Montreal, which has hosted a tournament with the
automated tables.
The tables feature no dealers — there is a centralized screen that shows a
dealer and the community cards. Each player has an individual m |
|
h*****u
发帖数: 34 | 5 二手交易风险自负！请自行验证是否合法和一手卡！:
Queen bed,Table and 4 Chairs(床,桌,椅)
我想卖的物品:
单张面值:
可接受价格(必须明码标价！):
Bed: $250
Table $80
4 Chairs total $100
物品新旧要求:
About 1 year, Multi-function
邮寄方式要求:
买卖双方谁承担邮寄损失(Required if not code only):
付款方式说明:
Cash
其他补充说明:
回国甩卖.
Queen bed: Mattress+Box asking for $250. Almost brand new, even with
package on Mattress as I have another Mattress. You can also use it as a
CABINET to store other stuffs (see pictures in Craiglist).
Table: You can extend the table when you have dinner an |
|
h*****u
发帖数: 34 | 6 我想卖的物品:
Queen bed,Table and 4 Chairs(床,桌,椅)
单张面值:
可接受的价格 (required):
Bed: $250
Table $80
4 Chairs total $100
物品新旧要求:
All less than 1 year, Multi-function
邮寄方式要求:
买卖双方谁承担邮寄损失(required if not code only):
付款方式说明:
Cash or Check
其他补充说明:
Moving Sale.
Queen bed: Mattress+Box asking for $250. Almost brand new, even with
package on Mattress as I have another Mattress. You can also use it as a
CABINET to store other stuffs (see pictures).
Table: You can extend the table when you have dinner and get them |
|
c*****h
发帖数: 14923 | 7 http://dealsea.com/view-deal/607249
Sur La Table has Staub 4-Quart Round Cocotte for $99.96 + $0.56 filler for $
100.52 - $20 w/code "TOYSLT15" = $80.52. Shipping is free.
Amex offer: $10 off $50 at Sur La Table. YMMV
结合amex amazon offer，去amazon买$60 Sur La Table的gc，还能多反$15。。。那
这个deal最低就能搞到$65.52
或者结合amex Sur La Table $10 back offer也可以，最后是$70.52，还有amex延长质保 |
|
d****o
发帖数: 1055 | 8 hash table里面存储key本身吗？比如说有5billion个超长的URL,我用md5 转换之后的
值作为hash table的key,然后把所有的URL存进hash table, 那么这个hash table 有多
大？多谢。能放进一个4GB内存的机器吗？
理论上面说，一个5billion个URL 被md5后有 5G*16B = 80GB。 |
|
l******9
发帖数: 579 | 9 【 以下文字转载自 Database 讨论区 】
发信人: light009 (light009), 信区: Database
标 题: sort two same tables SQL but different results
发信站: BBS 未名空间站 (Fri May 9 09:57:41 2014, 美东)
I am sorting two tables on SQL.
The two tables have the same column names and types and rows numbers.
I used order by to do sorting but the two tables are different in order.
Example,
SELECT *
FROM table1 AS t1
ORDER BY t1.col1 , t1.col2, t1.col3, t1.col4 ASC
SELECT *
FROM table2 AS t2
ORDER BY t2.col1 , t2.col2, t2.col3, t2.col4 ASC
T... 阅读全帖 |
|
l******9
发帖数: 579 | 10 【 以下文字转载自 Quant 讨论区 】
发信人: light009 (light009), 信区: Quant
标 题: SQL multiply all values of a column in table
发信站: BBS 未名空间站 (Wed Jun 25 17:35:13 2014, 美东)
I need to multiply all float values of a column in table if the column value
is positive. If I find a value is null or negative or not numeric, I raise
an error in SQL server 2008 R2.
given table t0:
col
1.5
2
given table t1:
col
2
-1
5
0
null
NaN
For t0 I should get 3, for t1, I should raise an error.
... 阅读全帖 |
|
s****s
发帖数: 2163 | 11 SQL TABLE 是不能有两个同名的COLUMN的，不知你想干嘛，但是似乎应该是往第二个
TABLE里加个REFERENCE KEY， LINK到第一个TABLE的一个ROW里。
another |
|
l******9
发帖数: 579 | 12 【 以下文字转载自 Database 讨论区 】
发信人: light009 (light009), 信区: Database
标 题: Truncation error import csv file to SQL table
发信站: BBS 未名空间站 (Wed Apr 29 15:28:46 2015, 美东)
I would like to import a .csv file into a SQL Server 2008R2 database table
on Win 7.
It has one column and one row.
File1:
name
runeocnu 430274 sjunosnv djduenvop 934m ljfonm3
I got error:
Error 0xc02020a1: Data Flow Task 1: Data conversion failed. The data
conversion for column "NAME" returned status value 4 and status text "Text
w... 阅读全帖 |
|
h******2
发帖数: 102 | 13 I actually did miter cut all 12' baseboards with a table saw for all my
baseboard installation. It was so inaccurate and dangerous. The problem was
that there was no way to move the long baseboard along with the miter guild
even you have a extension. My point is that for safty and good results it is
worth having a miter saw than just a table saw if people need to miter/
bevel cut very long lumbers.
New DIYers are clumpzy at power tools. You do not want to give them wrong
impressions that they ca... 阅读全帖 |
|
y********g
发帖数: 3097 | 14 【 以下文字转载自 Chicago 讨论区 】
发信人: yonghehong (yonghehong), 信区: Chicago
标 题: 为啥同是实木的dining table,大小差不多,价格差好远?
发信站: BBS 未名空间站 (Tue Mar 6 11:26:50 2012, 美东)
为啥同是实木的dining table,大小差不多,价格差好远?
在room and board看了oak dining table,桌子要1099,配套的椅子399一把.
ikea的pine dining table,一套加4个椅子才199.
是不是在room and board买家具性价比不高? |
|
I********h
发帖数: 230 | 15 这叫 ping pang table。不叫 table tennis table
你不嫌绕嘴吗？真是二 |
|
w****i
发帖数: 155 | 16 Table saw的真正长处是精准的做重复ripping，至于dado和groove用router或者router
table都可以搞定，而且还安全。 TS55这样的track saw的长处是精准的锯开大块的
plywood，
当然做厚木板的trim也不错。 在我看来， 做精细木工，table saw， track saw,
router table，miter saw 甚至还有band saw（现在还没买）一个都不能少。
做家装因为精度要求低，一般的circular saw，miter saw还有jig saw就足够应付了。 |
|
w******n
发帖数: 168 | 17 first time home owner....算entry level weekend warrior...
家里经常修修补补，需要切木头，院子里面需要搭个架子，修补下fence，做个planter
啥的，最近想在车库里面做几个storage shelf挂工具，然后就是想给娃做个木马
放客厅的家具是做不出来的，做出来ld也不准往客厅放。。。
手里有circular saw和jig saw，可惜圆锯还是精度差些，关键每次都得用clamp钳好
效率太低....
jig saw 12V的 还是不太给力 切个2X4都很吃力
最近想买锯, ld批的预算500刀，车库太小没有太多空间， 是买job site table saw还
是miter saw？
基本把帖子扫了一遍，木工大牛们基本推荐table saw，可以调整校准的地方多，算万
锯之王
可惜kickback还是挺吓人,还要配各种jig， miter gauge 和outfeed table啥的 买的
话真心不便宜.... diy的话 还是花时间多，精度也不好控制
miter saw 安全傻瓜 精度也还行，基本家里的活也能干了，关键是快... 阅读全帖 |
|
w****e
发帖数: 1013 | 18 想买一个diaper changing table，就是上面那个宝宝躺的盒子是可以倾斜放，一头高
一点的那种。我家宝宝刚吃完就平放的话容易吐奶，而在一个倾斜的平面上呆一会儿会
好很多。现在的方法是上半身放在个大人睡的枕头或者被子上，可是时间长了对颈椎不
好。刚生完住院的时候见医院用的这种changing table，觉得放在这样的table里面既
可以防止吐奶，表面又是硬的，应该是不错。不过不知道市面上卖的table里哪个有这
个功能。看了很多产品说明，没有看到有对这个说明的。不知道这里的JMS有没有人用过，麻烦推荐一下。谢谢
！ |
|
f******e
发帖数: 2888 | 19 我们的changing table是跟crib一套从walmart买的，当时买的时候图的是
changingtable下面的dresser，觉得比较实用。现在宝宝10个月，觉得dresser，
changing table， crib中最有用的就是changing table
最主要的原因是我自己 本来腰就不好，也不年轻了，换尿片能够站着换是多么的省力
啊。
有几天住在另外的地方，就在床上，沙发上都换过，无比想念changing table。
一个是自己省力，
另外一个，小孩子没得机会左右翻滚，顶多只能趴过来，但这不影响我给她带尿片，要
是她两下滚走了，还得拖拉，很麻烦。而且如果 在尿片套上前 尿了（或者拉），八成
又要换洗床单了。
还有所有与换尿片相关的东西都在手边啊，垫子就不动了，尿片（日用，夜用）就在台
子下，换的衣服也在台子下的抽屉里，很方便。如果在床上换，东西经常有够不着的，
要么抱着光屁股宝宝走过去拿，要么喊人。那个台子高，我们3个月后，宝宝在台上从
不离人，也不需要走开，因为东西都在手边。
换尿片地点固定后，尿布桶也就随之固定。很方便。
总的来说，我觉得很值。 |
|
o**********5
发帖数: 4327 | 20 糊糊啊泥啊，打得越细越喜欢吃，尤其喜欢吃罐头那么细的
自己打的蔬菜泥或者是肉泥，有时候没那么细，他就不爱吃，吃几口就别脸啃high
chair去了
可以吃粥，还是嫌有块儿，吃得不多，得和菜泥一起喂才能多吃点
水果倒是可以吃些成块儿的，香蕉一咬一大口，也没见噎着，苹果可以自己捧着啃，不
过只有两颗牙，也啃不下来啥，我给他切片吃，他又不肯吃了
table food给尝试过，菜啊肉啊煮很烂了给吃，他倒是觉得很新鲜，一开始很兴奋，前
几口不错，再吃几口就撇嘴苦瓜脸，再吃几口又拒绝了，也不知道哪儿不合他的意了
这娃是吞咽问题还是咀嚼问题啊？
看到许多娃像毛头这么大都拒绝吃糊糊了，我们这位咋还这么爱糊糊呢，要不要多训练
他吃table food呢？还是长大自然就爱吃了？
让他吃table food实在很烦啊，吃糊糊好痛快啊，后妈我老想偷懒天天喂糊糊算了，又
怕不多训练他吃table food不好 |
|
c******s
发帖数: 1271 | 21 现在dresser和changing table都没买呢。
因为现在还在住apt，不想置办太多的家具。想参考下大家的意见。
喜欢changing table下边的开放的架子，所以本来的打算是买个changing table，孩子
的衣服就放那种透明的塑料柜子。大家觉得哪个更有用啊？买了dresser改装成
changing table用一段时间？ |
|
d*****a
发帖数: 3983 | 22 哦,买吧买吧.小男生可喜欢这个了.
我儿子刚两岁,每天早上一下楼就直扑train table,
不过2岁左右的孩子还不知道怎么拼,
我儿子总是要让我们给他拼好然后他拿着个车车顺着轨道绕着table跑.:)
大宝小的时候家里地方小,我只买了train没买table,
二宝刚出生遇到target 大减价,20$就扛了个全新的table回来,:) |
|
|
b********r
发帖数: 709 | 24 scopus上引用的table如果想拿来放在申请材料里，可以只把table那快切出来吗？
还是要把整个网页贴进去。
问题是，如何证明这是scopus上的table？
另外，好像Google上发现有几篇引用没有包含在scopus上的table里，应该说吗？如何
说？scopus上的引用大概20吧。
谢谢 |
|
r******n
发帖数: 2730 | 25 Hi all..new or old purduer..
if you are good at table tennis, please join our purdue table tennis club.
we will be competing in NCTTA (National Collegiate table tennis) tournament
in this coming Nov. and next Feb. We also regularly participate in regional
or national table tennis tournament as a group. we are looking for new blood
! please read the self-rating rules below, if you feel you are higher than 5
.0 please join us and practice together for the tournament.
anyone below 5.0 is also welc |
|
s********1
发帖数: 235 | 26 【 以下文字转载自 Database 讨论区 】
发信人: someone111 (some), 信区: Database
标 题: 如何把一个correlation matrix 按照一个table 输入一个 database 里？
发信站: BBS 未名空间站 (Tue Dec 8 16:13:07 2015, 美东)
如何把一个correlation matrix 按照一个table 输入一个 database 里？有大约1000,
000 X 1000, 这么多vectors ，每一对vectors 算一个 correlation, 要输到database
的表里，每一个vector 都有一个常量string 对应，所以不牵扯把vector 输到
database table 里。怎么弄比较好？主要以后可能要拿这些代表 vector 的常量
string 做key join table. |
|
c*********n
发帖数: 96 | 27 价格好商量！
http://seattle.craigslist.org/see/fuo/3897222611.html
Extendable formal dining table set with 6 matching chairs, all SOLID WOOD (
cherry) with antique design! We are a none smoking home.
The table is 5.5 feet x 3.5 feet. The table can be extended to a total
length of 7.5 ft with the two extension boards. Asking $250.00 OBO for the
entire set. There are some blemishes on the surface one end of the table.
The back of one chair has a tear on it. Other than that, this is a great set
for your ... 阅读全帖 |
|
I*******d
发帖数: 77 | 28 同胞可以算便宜一点
http://seattle.craigslist.org/see/fuo/5213083571.html
Extendable formal dining table set with 6 matching chairs, all SOLID WOOD (
cherry) with antique design! We are a none smoking home.
The table is 5.5 feet x 3.5 feet. The table can be extended to a total
length of 7.5 ft with the two extension boards. Asking $198.00 OBO for the
entire set. There are some blemishes on the surface one end of the table.
Other than that, this is a great set for your formal dining room. |
|
s********1
发帖数: 235 | 29 【 以下文字转载自 Database 讨论区 】
发信人: someone111 (some), 信区: Database
标 题: 如何把一个correlation matrix 按照一个table 输入一个 database 里？
发信站: BBS 未名空间站 (Tue Dec 8 16:13:07 2015, 美东)
如何把一个correlation matrix 按照一个table 输入一个 database 里？有大约1000,
000 X 1000, 这么多vectors ，每一对vectors 算一个 correlation, 要输到database
的表里，每一个vector 都有一个常量string 对应，所以不牵扯把vector 输到
database table 里。怎么弄比较好？主要以后可能要拿这些代表 vector 的常量
string 做key join table. |
|
E***s
发帖数: 855 | 30 【 以下文字转载自 Living 讨论区 】
发信人: Eurus (Suffer Mortals), 信区: Living
标 题: 请教关于在Laminate地板上放heavy pool table
发信站: BBS 未名空间站 (Mon Nov 24 12:07:27 2014, 美东)
最近刚铺了Laminate地板，就是Costco里的那种，可能是8mm厚。
还从Costco网上订了American Heritage的pool table，上面写了Approximate
shipping weight is 950 lbs，不清楚net weight多少。
刚刚打电话给support问了一下，地板的说他们最多支持700lb，多了会有dent，然后会
影响地板伸缩，不给保修。卖pool table的说有area rug和Rubber Pool Table Shims
就没什么问题。想问问版上有没有有实际经验的，了解一下倒地情况怎么样，会对地板
造成多大损伤，有问题么？ |
|
b****g
发帖数: 7311 | 31 "A personal purchase by President Obama, the Obamas selected a Tournament
Series Table Tennis Model from Stiga for the White House. With its
tournament-grade top and heavy duty chassis, the table is designed for
aggressive play and family fun, which are the qualities the Obamas were
looking for in a table tennis table" |
|
s*******o
发帖数: 4896 | 32 最近打比较多FTP上的rush tournment，进了2次final table，
stack大概都是5,6左右，一般也不会比第9多多少。
final table开始的时候比较紧，因为大筹码的玩家总是打得很凶。到最后淘汰掉1,2个
人以后，我往往就只剩下不到10个BB，以至于抓到A suited或者小对子都all in进去，
经常结果很惨。
想问问进final table中下筹码的玩家在final table上应该用什么样的策略能最大化盈
利。 |
|
r*********o
发帖数: 3337 | 33 十个月的娃貌似对train table很感兴趣，图书馆的story time有一个，每次都玩得很
欢，主要是扶着table站着，拿着火车啃，那天带他去mall里一个玩具店，玩了半天
train table，抱他走的时候还哭。
是不是应该在家里置办一个了？
可是train table好像是给2岁以上孩子玩的吧，太早了点？ |
|
T*****e
发帖数: 361 | 34 想要的效果就是把一个网页的内容分为上、中、下三部分，
分别是header, contents, and footer，并且header紧靠
页面顶端，然后是内容，而footer则紧靠页面底端。
实现的思路是：
1 html body高、宽都设为100%
2 第一个table上下两格，上格嵌套一个table用来放
header和内容，向上垂直对齐；下格放footer，向下垂直
对齐。这个table高宽都为100%。
3 嵌套的table也是上下两格，上格放header，下格放内
容。
html代码附后。
问题：在IE中看着好像没有问题，但是FireFox中footer还是
紧靠在内容后面，并没有紧贴页面底端。使用DOM Inspector
发现html body的大小并没有覆盖整个页面，不知道为什么？
PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
b******u
发帖数: 676 | 35 I have an SQL server database host on the server. And I have a tiny Access
application, which just includs some reports, base on those SQL server tables.
I used link table in the Access.
The problem is, to use link table, I need to set up ODBC for the SQL server. I
set it up on the computer that SQL db is hosted. Both Access application and
the SQL server are on network. I want to open the Access application from
another computer in the network, but I got error that says "ODBC - connection
to [S | |
|
w***y
发帖数: 6251 | 36 f=# \h drop table
Command: DROP TABLE
Description: remove a table
Syntax:
DROP TABLE name [, ...]
好象也没啥有用的信息， 我现在都怀疑这个postgresal有点不对 |
|
b*e
发帖数: 3845 | 37 Need help designing a table.
I need to design an employee-department history tracking table
1. Keep track of when an employee got hired
2. Keep track of when an employee switched departments
within the compnay
3. keep track of when an employee got terminated.
My initial design of the table schema is like this:
tblEmployeeDeptHistory
(
EmployeeId int,
DeptId int,
DateStart DateTime,
DateEnd DateTime
)
Assuming the employeeId is a foreign key of another 'employee'
table, and DeptId is |
|
b****r
发帖数: 113 | 38 mysql version 4.0.20a, on winxp. Innodb type table.
I use "alter table tbl_name drop col_name" to drop a column,
but it failed twice.
From the dos window on XP, the comman "alter table" hang on there for ever.
After reboot the machine, the column is still there,
and data in this column are still fine.
The table has about 20 million rolls. Is the size a prolbem?
Thanks for any help. |
|
c***n
发帖数: 921 | 39 ** in db2 **
I have table B; now I want to create a new table A, which contains the first
500 rows from B.
I have created the structure of A, which is successfully executed.
Now I want to populate table A.
If I run:
insert into A (select * from B)
It populates A with all the rows from B;
If I run:
insert into A (
select * from B
fetch first 500 rows only)
It generates error "keyword fetch is not expected here"
How can I just get the first 500 rows from B? |
|
n********6
发帖数: 1511 | 40 请教query，请教比较两个table，找出相同和不同的records
SQL 2005
一个在server 1，一个在server 2。
表结构相同。
表数据不同，有共同拥有的纪录(records)，也有各自独有的纪录(records)。
server 1, server 2是 linked server，可以直接query。
table 不大，thousands of records。用于看看到底有什么异同。不考虑performance。
table a, sample:
aid, a_environment, a_description...
1, aaa, abcd,...
1, bbb, xyzn,...
1, ccc, ddeea,...
1, ddd, jdie,...
2, aaa, ...
2, bbb, ...
2, ddd, ...
4, aaa, ...
4, ddd, jjgd,
5, ......
...
table b, sample
bid, b_environment, b_description...
2, aa |
|
k*******1
发帖数: 22 | 41 truncate table了，column names, index, permission都还在的？？？
就是说如果truncate table了以后又想加入数据到这个table，就不用再create table
了，直接
insert就行？？ |
|
v*****r
发帖数: 1119 | 42 这个 error 是不是你 load external table data 到 regular table 时产生的？
可能 the rejected row in external table actually has 144 characters in
length, but column in regular table being updated is defined as VARCHAR2(100
). |
|
R*********r
发帖数: 225 | 43 yeah，这个是工作的。多谢。
不过如果我想让#test的结构在不同的条件下完全不一样就不行了，不好事先定义。
下面两个例子，第一个报错，说#Test 已经存在，但是如果我把它换成一个permanent
table就完全没问题。
BTW: 用的是SQL SERVER 2008 R2
IF (2>1)
BEGIN
IF OBJECT_ID(N'tempdb.dbo.#Test','U') IS NOT NULL DROP TABLE #Test
SELECT 1 AS col1 into #Test
END
ELSE
BEGIN
IF OBJECT_ID(N'tempdb.dbo.#Test','U') IS NOT NULL DROP TABLE #Test
SELECT 2 as col1 INTO #Test
END
IF (2>1)
BEGIN
IF OBJECT_ID(N'dbo.test','U') IS NOT NULL DROP TABLE dbo.test
SELECT 1 AS col1 into dbo.test
END
ELSE
BEGIN
IF OBJECT_I |
|
m****e
发帖数: 1197 | 44 TABLE A，里面有2条数据， 如下：
Hierarchy Level 1 Level 2 Level 3 Level 4 Leaf
ACCT_REPORTING ACCOUNT BALANCES OFF_BAL_SHEET
Acct1234
ACCT_REPORTING ACCOUNT MEMO_ACCOUNT AWARD_EXPCT
Acct4321
TABLE B，里面也是2条数据，如下；
Hierarchy Level 1 Level 2 Level 3 Level 4 Leaf
ACCT_REPORTING ACCOUNT BALANCES OFF_BAL_SHEET ALS_UNFUNDED
Acct1234
ACCT_REPORTING ACCOUNT MEMO_ACCOUNT AWARD_EXPCT ... 阅读全帖 |
|
m******1
发帖数: 98 | 45 MS ACCESS 里面怎么把两个Table combine 到一个table, 而且primary key不重复呢？
Query可以把两个并到一起，但是我想直接把他们并成一个table.而且ID 不重复。
不知道怎么弄，请教。 谢谢。 |
|
y****9
发帖数: 144 | 46 Sometime to answer a question is very difficult because the question does
not describe the whole story. If I ask how to cut a tree, the answer could
be using an ox or saw; but if I ask how can I cut a tree to get the apples?
you will most likely ask why you need to cut the tree? You may use the
ladder.
I read some where that the famous "Tom Kyte turn around" to answer a
question is to ask " why?" first (Tom Kyte is Oracle guru)
Why do you need to sync up the two tables? what is your database /ve... 阅读全帖 |
|
g***l
发帖数: 18555 | 47 建一个一模一样的TABLE名字是TABLE_TEMP，注意PK, INDEXES， BULK INSERT你想留住
的RECORD INTO TABLE_TEMP，DROP OLD TABLE, RENAME TABLE_TEMP TO TABLE,
RECOMPILE TABLE |
|
g***l
发帖数: 18555 | 48 建一个一模一样的TABLE名字是TABLE_TEMP，注意PK, INDEXES， BULK INSERT（或者BCP）你想留住
的RECORD INTO TABLE_TEMP，DROP OLD TABLE, RENAME TABLE_TEMP TO TABLE,
RECOMPILE TABLE,没做好INDEX，又没弄PARTITION的，只嫩用这种方法 |
|
g***l
发帖数: 18555 | 49 tables are objects , there are properties you have to set, like ownership,
user. What if users do not exists, or there is a table already exists in the
targeted database. You have to make manual decisitions. copying table is no
different from re-creating table and setting properties and copying data
over. |
|
c*********e
发帖数: 16335 | 50 比如一個star schema,要把各个dimension table的数据拷贝到fact table里面，拷贝
完后，就只对这个fact table做各种query. |
|
