web外部表--有更新版本！

最新推荐文章于 2022-06-24 13:44:47 发布
最新推荐文章于 2022-06-24 13:44:47 发布
阅读量1.3k 收藏
点赞数 1
分类专栏： GPDB Mangement
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/gtlions/article/details/8872365
版权
web外部表
在某些情况下，比如在多个系统之间进行数据传递的时候，可能对方会将文件放到网站上，然后你自己去下载，别觉得奇怪，我至少碰到过两次这样的数据交互方式，而且是在金融业和互联网行业。在这个情况下使用web协议直接创建的外部表就很有好处了。

[root@o564gtser1 html]# echo 'test'>1.html
[root@o564gtser1 html]# pwd
/var/www/html
[root@o564gtser1 html]# cat 1.html
test

gtlions=# create external web table e_web1(txt text) location ('http://o564gtser1/1.html') format 'text' (delimiter 'off');                                            CREATE EXTERNAL TABLE
gtlions=# select * from e_web1;                                                                                                                                         txt  
------
 test
(1 row)

gtlions=# drop external table e_web1;
DROP EXTERNAL TABLE
gtlions=# create external web table e_web1(txt text) location ('http://www.baidu.com/index.htm') format 'text' (delimiter 'off');
CREATE EXTERNAL TABLE
gtlions=# select * from e_web1;                                                                                                                                                                                                                                                                                                               
                                                                                                                                                                       
                                                                                                                                                                       
                                                                                                                                                                       
                                                                                                                                                                       
                                                                                                                                                                       
                                                                                                                                                                       
                                                                                                                                                                       
                                                                                                                                                                       
                                                                                                                                                                       
                                                                                                                                                                       
                                                                                                                                                                       
                                                                                                                                                                       
                                                                                                                                                                       
                                                                                                                                                                       
                                                                                                                                                                       
                                                                                                                                                                       
                                                                                                                                                                       
                                                                                                                                                                       
                                                                                                                                                                       
                                                                                                                                                                       
                                                                                                                                                                       
                                                                                                                                                                       
                                                                                                                                                                       
                                                                                                                                                                       
                                                                                                                                                                       
                                                                                                                                                                       
                                                                                                                                                                       
                                                                                                                                                                       
                                                                                                                                                                       
                                                                                                                                                                       
                                                                                                                      txt                                              
                                                                                                                                                                       
                                                                                                                                                                       
                                                                                                                                                                       
                                                                                                                                                                       
                                                                                                                                                                       
                                                                                                                                                                       
                                                                                                                                                                       
                                                                                                                                                                       
                                                                                                                                                                       
                                                                                                                                                                       
                                                                                                                                                                       
                                                                                                                                                                       
                                                                                                                                                                       
                                                                                                                                                                       
                                                                                                                                                                       
                                                                                                                                                                       
                                                                                                                                                                       
                                                                                                                                                                       
                                                                                                                                                                       
                                                                                                                                                                       
                                                                                                                                                                       
                                                                                                                                                                       
                                                                                                                                                                       
                                                                                                                                                                       
                                                                                                                                                                       
                                                                                                                                                                       
                                                                                                                                                                       
                                                                                                                                                                       
                                                                                                                                                                       
                                                                                                                                                                       
                                                                                                                                                                       
                                                                        
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------
 <!DOCTYPE html><!--STATUS OK-->    <html><head>  <meta http-equiv="content-type" content="text/html;charset=utf-8">  <title>百度一下，你就知道</title> <style >html,bo
dy{height:100%}html{overflow-y:auto}#wrapper{position:relative;_position:;min-height:100%}#content{padding-bottom:100px;text-align:center}#ftCon{height:100px;position:
absolute;bottom:44px;text-align:center;width:100%;margin:0 auto;z-index:0;overflow:hidden}#ftConw{width:720px;margin:0 auto}body{font:12px arial;text-align:;background
:#fff}body,p,form,ul,li{margin:0;padding:0;list-style:none}body,form,#fm{position:relative}td{text-align:left}img{border:0}a{color:#00c}a:active{color:#f60}#u{color:#9
99;padding:4px 10px 5px 0;text-align:right}#u a{margin:0 5px}#u .reg{margin:0}#m{width:720px;margin:0 auto}#nv a,#nv b,.btn,#lk{font-size:14px}#fm{padding-left:110px;t
ext-align:left;z-index:1}input{border:0;padding:0}#nv{height:19px;font-size:16px;margin:0 0 4px;text-align:left;text-indent:137px}.s_ipt_wr{width:418px;height:30px;dis
play:inline-block;margin-right:5px;background:url(http://s1.bdstatic.com/r/www/img/i-1.0.0.png) no-repeat -304px 0;border:1px solid #b6b6b6;border-color:#9a9a9a #cdcdc
d #cdcdcd #9a9a9a;vertical-align:top}.s_ipt{width:405px;height:22px;font:16px/22px arial;margin:5px 0 0 7px;background:#fff;outline:0;-webkit-appearance:none}.s_btn{wi
dth:95px;height:32px;padding-top:2px\9;font-size:14px;background:#ddd url(http://s1.bdstatic.com/r/www/img/i-1.0.0.png);cursor:pointer}.s_btn_h{background-position:-10
0px 0}.s_btn_wr{width:97px;height:34px;display:inline-block;background:url(http://s1.bdstatic.com/r/www/img/i-1.0.0.png) no-repeat -202px 0;*position:relative;z-index:
0;vertical-align:top}#lg img{vertical-align:top;margin-bottom:3px}#lk{margin:33px 0}#lk span{font:14px "宋体"}#lm{height:60px}#lh{margin:16px 0 5px;word-spacing:3px}.t
ools{position:absolute;top:-4px;*top:10px;right:7px}#mHolder{width:62px;position:relative;z-index:296;display:none}#mCon{height:18px;line-height:18px;position:absolute
;cursor:pointer;padding:0 18px 0 0;background:url(http://s1.bdstatic.com/r/www/img/bg-1.0.0.gif) no-repeat right -134px;background-position:right -136px\9}#mCon span{c
olor:#00c;cursor:default;display:block}#mCon .hw{text-decoration:underline;cursor:pointer}#mMenu a{width:100%;height:100%;display:block;line-height:22px;text-indent:6p
x;text-decoration:none;filter:none\9}#mMenu,#user ul{box-shadow:1px 1px 2px #ccc;-moz-box-shadow:1px 1px 2px #ccc;-webkit-box-shadow:1px 1px 2px #ccc;filter:progid:DXI
mageTransform.Microsoft.Shadow(Strength=2,Direction=135,Color="#cccccc")\9}#mMenu{width:56px;border:1px solid #9b9b9b;list-style:none;position:absolute;right:27px;top:
28px;display:none;background:#fff}#mMenu a:hover{background:#ebebeb}#mMenu .ln{height:1px;background:#ebebeb;overflow:hidden;font-size:1px;line-height:1px;margin-top:-
1px}#cp,#cp a{color:#666}#seth{display:none;behavior:url(#default#homepage)}#setf{display:none}#sekj{margin-left:14px}#shouji{margin-right:14px}</style> <script>functi
on h(obj){obj.style.behavior='url(#default#homepage)';var a = obj.setHomePage('http://www.baidu.com/');}</script></head><body>  <div id="wrapper"><div id="content"> <d
iv id="u"><a href="http://www.baidu.com/gaoji/preferences.html" name="tj_setting">搜索设置</a>|<a href="https://passport.baidu.com/v2/?login&tpl=mn&u=http%3A%2F%2Fwww.
baidu.com%2F" name="tj_login" id="lb" οnclick="return false;">登录</a><a href="https://passport.baidu.com/v2/?reg&regType=1&tpl=mn&u=http%3A%2F%2Fwww.baidu.com%2F" tar
get="_blank" name="tj_reg" class="reg">注册</a></div> <div id="m"> <p id="lg"><img src="http://www.baidu.com/img/0501-s_f5813263d8c8b6e79942bbeb2953ce8f.gif" width="27
0" height="129"  usemap="#mp" ><map name="mp"><area shape="rect" coords="5,7,267,125" href="http://www.baidu.com/s?wd=%E4%BA%94%E4%B8%80" target="_blank"  title="同心
手，重建家园"   οnmοusedοwn="return ns_c({'fm':'behs','tab':'bdlogo'})" ></map></p> <p id="nv"><a href="http://news.baidu.com">新&nbsp;闻</a>　<b>网&nbsp;页</b>　<a hr
ef="http://tieba.baidu.com">贴&nbsp;吧</a>　<a href="http://zhidao.baidu.com">知&nbsp;道</a>　<a href="http://music.baidu.com">音&nbsp;乐</a>　<a href="http://image.ba
idu.com">图&nbsp;片</a>　<a href="http://video.baidu.com">视&nbsp;频</a>　<a href="http://map.baidu.com">地&nbsp;图</a></p><div id="fm"><form name="f" action="/s"><spa
n class="s_ipt_wr"><input type="text" name="wd" id="kw" maxlength="100" class="s_ipt"></span><input type="hidden" name="rsv_bp" value="0"><input type=hidden name=ch va
lue=""><input type=hidden name=tn value="baidu"><input type=hidden name=bar value=""><input type="hidden" name="rsv_spt" value="3"><input type="hidden" name="ie" value
="utf-8"><span class="s_btn_wr"><input type="submit" value="百度一下" id="su" class="s_btn" οnmοusedοwn="this.className='s_btn s_btn_h'" οnmοuseοut="this.className='s_
btn'"></span></form><span class="tools"><span id="mHolder"><div id="mCon"><span>输入法</span></div></span></span><ul id="mMenu"><li><a href="#" name="ime_hw">手写</a><
/li><li><a href="#" name="ime_py">拼音</a></li><li class="ln"></li><li><a href="#" name="ime_cl">关闭</a></li></ul></div> <p id="lk"><a href="http://baike.baidu.com">
科</a>　<a href="http://wenku.baidu.com">文库</a>　<a href="http://www.hao123.com">hao123</a><span> | <a href="http://www.baidu.com/more/">更多&gt;&gt;</a></span></p><
p id="lm"></p> </div> </div> <div id="ftCon"><div id="ftConw"> <p ><a id="seth" onClick="h(this)" href="/" οnmοusedοwn="return ns_c({'fm':'behs','tab':'homepage','pos'
:0})">把百度设为主页</a><a id="setf" href="http://www.baidu.com/cache/sethelp/index.html" οnmοusedοwn="return ns_c({'fm':'behs','tab':'favorites','pos':0})" target="_b
lank">把百度设为主页</a><span id="sekj"><a href="http://liulanqi.baidu.com/ps.php" target="_blank" οnmοusedοwn="return ns_c({'fm':'behs','tab':'bdbrwlk','pos':1})">安
百度浏览器</a></span></p><p id="lh"><a href="http://e.baidu.com/?refer=888" οnmοusedοwn="return ns_c({'fm':'behs','tab':'btlink','pos':2})">加入百度推广</a> | <a onmou
sedown="return ns_c({'fm':'behs','tab':'tj_bang'})" href="http://top.baidu.com">搜索风云榜</a> | <a οnmοusedοwn="return ns_c({'fm':'behs','tab':'tj_about'})" href="htt
p://home.baidu.com">关于百度</a> | <a οnmοusedοwn="return ns_c({'fm':'behs','tab':'tj_about_en'})" href="http://ir.baidu.com">About Baidu</a></p><p id="cp">&copy;2013
Baidu <a href="/duty/" name="tj_duty">使用百度前必读</a> 京ICP证030173号 <img src="http://www.baidu.com/cache/global/img/gs.gif"></p></div></div> </div> </body><script
>var bds={se:{},comm : {ishome : 1,sid : "1439_1944_1788_2250_2252_2361",user : "",username : "",sugHost : "http://suggestion.baidu.com/su",personalData : "",loginActi
on : []}}</script><script type="text/javascript" src="http://s1.bdstatic.com/r/www/cache/global/js/home-2.10.js" charset="gbk"></script><script>var bdUser = null;var w
=window,d=document,n=navigator,k=d.f.wd,a=d.getElementById("nv").getElementsByTagName("a"),isIE=n.userAgent.indexOf("MSIE")!=-1&&!window.opera;(function(){if(/q=([^&]+
)/.test(location.search)){k.value=decodeURIComponent(RegExp["\x241"])}})();if(n.cookieEnabled){bds.se.sug();};function addEV(o, e, f){if(w.attachEvent){o.attachEvent("
on" + e, f);}else if(w.addEventListener){ o.addEventListener(e, f, false);}}function G(id){return d.getElementById(id);}function ns_c(q){var p = encodeURIComponent(win
dow.document.location.href), sQ = '', sV = '', mu='', img = window["BD_PS_C" + (new Date()).getTime()] = new Image();for (v in q) {sV = q[v];sQ += v + "=" + sV + "&";}
 mu= "&mu=" + p ;img.src = "http://nsclick.baidu.com/v.gif?pid=201&pj=www&rsv_sid=1439_1944_1788_2250_2252_2361&" + sQ + "path="+p+"&t="+new Date().getTime();return tr
ue;}if(/\bbdime=[12]/.test(d.cookie)){document.write('<script src=http://s1.bdstatic.com/r/www/cache/ime/js/openime-1.0.1.js charset="gbk"><\/script>');}(function(){va
r u = G("u").getElementsByTagName("a"), nv = G("nv").getElementsByTagName("a"), lk = G("lk").getElementsByTagName("a"), un = "";var tj_nv = ["news","tieba","zhidao","m
p3","img","video","map"];var tj_lk = ["baike","wenku","hao123","more"];un = bds.comm.user == "" ? "" : bds.comm.user;function _addTJ(obj){addEV(obj, "mousedown", funct
ion(e){var e = e || window.event;var target = e.target || e.srcElement;ns_c({'fm':'behs','tab':target.name||'tj_user','un':encodeURIComponent(un)});});}for(var i = 0;
i < u.length; i++){_addTJ(u[i]);}for(var i = 0; i < nv.length; i++){nv[i].name = 'tj_' + tj_nv[i];}for(var i = 0; i < lk.length; i++){lk[i].name = 'tj_' + tj_lk[i];}})
();(function() {var links = {'tj_news': ['word', 'http://news.baidu.com/ns?tn=news&cl=2&rn=20&ct=1&ie=utf-8'],'tj_tieba': ['kw', 'http://tieba.baidu.com/f?ie=utf-8'],'
tj_zhidao': ['word', 'http://zhidao.baidu.com/search?pn=0&rn=10&lm=0'],'tj_mp3': ['key', 'http://music.baidu.com/search?fr=ps&ie=utf-8'],'tj_img': ['word', 'http://ima
ge.baidu.com/i?ct=201326592&cl=2&nc=1&lm=-1&st=-1&tn=baiduimage&istype=2&fm=&pv=&z=0&ie=utf-8'],'tj_video': ['word', 'http://video.baidu.com/v?ct=301989888&s=25&ie=utf
-8'],'tj_map': ['wd', 'http://map.baidu.com/?newmap=1&ie=utf-8&s=s'],'tj_baike': ['word', 'http://baike.baidu.com/search/word?pic=1&sug=1&enc=utf8'],'tj_wenku': ['word
', 'http://wenku.baidu.com/search?ie=utf-8']};var domArr = [G('nv'), G('lk'),G('cp')],kw = G('kw');for (var i = 0, l = domArr.length; i < l; i++) {domArr[i].onmousedow
n = function(e) {e = e || window.event;var target = e.target || e.srcElement,name = target.getAttribute('name'),items = links[name],reg = new RegExp('^\\s+|\\s+\x24'),
key = kw.value.replace(reg, '');if (items) {if (key.length > 0) {var wd = items[0], url = items[1],url = url + ( name === 'tj_map' ? encodeURIComponent('&' + wd + '='
+ key) : ( ( url.indexOf('?') > 0 ? '&' : '?' ) + wd + '=' + encodeURIComponent(key) ) );target.href = url;} else {target.href = target.href.match(new RegExp('^http:\/
\/.+\.baidu\.com'))[0];}}name && ns_c({'fm': 'behs','tab': name,'query': encodeURIComponent(key),'un': encodeURIComponent(bds.comm.user || '') });};}})();addEV(w,"load
",function(){k.focus()});w.οnunlοad=function(){};</script><script type="text/javascript" src="http://s1.bdstatic.com/r/www/cache/global/js/tangram-1.3.4c1.0.js"></scri
pt><script type="text/javascript" src="http://s1.bdstatic.com/r/www/cache/user/js/u-1.3.7.js" charset="gbk"></script><script>try{document.cookie="WWW_ST=;expires=Sat,
01 Jan 2000 00:00:00 GMT";baidu.on(document.forms[0],"submit",function(){var _t=new Date().getTime();document.cookie = "WWW_ST=" + _t +";expires=" + new Date(_t + 1000
0).toGMTString()})}catch(e){}</script></html><!--1c04264d311585a5-->
(1 row)

比较恐怖的是竟然是抓取源码的，这个貌似就比较鸡肋了，但是对于平面文件的功能还是很不错的。当然了，基于http的外部表是不支持writable的。
-EOF-
gtlions
关注
  • 1
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
GP加载和卸载数据之一外部表--有更新版本！
Gtlions Tracker
04-30 3453
7.0. 方式 在gp中提供了几种方式用于加载和卸载数据：external tables、gpload、copy等等，这几种方式没有优劣之分，只是在不同场景下使用不同的技术而已。 7.1. 外部表 本文将首先测试使用外部表的方式进行加载和卸载数据。 外部表-external tables，分为只读readable和只写writable两种类别，而每种又可以分为常规regular和web两种
Greenplum Web External Tables事例
朝着梦想 渐行前进
06-15 2158
Defining Command-Based Web External Tables执行的命令或者程序需要在主机上已经存在，创建外部表的命令时可以在ON关键字后面指定在哪些节点上执行。ON ALL| MASTER| number_of_segments| HOST [segment_hostname]| SEGMENT segment_id ]下面给出几个例子
【第二更】WEB系统版本及自动更新管理系统
笃思胜行
11-14 564
昨天写到的登录功能，大家可以使用postman测试下 接下来我们开始写业务模块了，更新包管理与客户端管理都是属于单表操作，所以只要做个GRUD功能即可。以更新包管理为例； 首先我们还是在控制器目录下创建一个更新包管理的控制器Upgradepackage.php <?php defined('BASEPATH') OR exit('No direct script acce...
GreenPlum 外部表external table 实战
csdn's blog
08-01 1万+
在第一个greenplum集群下面的master服务器上，启动gpfdist服务，在00_mdw启动gpfdist服务 执行启动命令： nohup $GPHOME/bin/gpfdist -d /home/gpadmin -p 8888 > /tmp/gpfdist.log 2>&1 & 查看启动日志：cat /tmp/gpfdist.log，日志信息如下： [r...
外部表（EXTERNAL TABLE）
搞怪的索引
05-08 4631
来自：http://blog.itpub.net/post/12524/461332 external table可以实现将flat file的内容不用真正装载到数据库，就跟使用数据库内部的表一样来使用。只是不能对这种类型的表进行DML和INDEX操作。这样方便我们在flat file和数据库表之间load和unload数据。 这个功能在oracle 9i上就实现了，当时仅
创建外部表（external table）
05-19 1146
Upload “Email-Match Export.csv” to the SFTP Server ------------create directory create directo...
web os commander外部表--有更新版本！
Gtlions Tracker
05-04 948
web外部表是只读的的，不像常规的外部表那样可以有写入的，而os commander web外部表的一个变形体，具体看几个例子。 gtlions=# create external web table e_web2 (like emp) execute 'cat ~/gpfdist/emp_exp.txt' format 'text'; CREATE EXTERNAL TABLE gtlio
SpringBoot 2.3--2.7版本更新汇总
热门推荐
没有简介
06-24 1万+
1、最低要求变更Gradle 6.3+（如果您使用 Gradle 构建）。Jetty 9.4.22+（如果您使用 Jetty 作为嵌入式容器）2、jdk支持添加了对 Java 14 的支持。也支持 Java 8 和 11。3、ElasticSearchNative Elasticsearch transport 已被删除，默认使用Elasticsearch 7.5+。4、MongoDB切换到mongodb4，并适配 reactive 和 imperative drivers。如果你使用 `spring-bo
GreenPlum--外部表
唐僧洗头爱飘柔
04-22 1765
外部表： 1、外部表允许用户像访问标准数据库表一样的访问外部表。 2、结合GP的并行文件分配程序（gpfdist），外部表支持在装载和卸载数据时全并行化利用所有segment实例的资源。 3、GP还可以利用Hadoop分布式文件系统的并行架构来访问文件。 GP提供了两种类型的外部表： 可读外部表：用于数据装载，不允许对数据进行修改。 可写外部表：用于数据卸载，从数据库表中选择记录并输出到文件、命令...
SAP-ECC-6中WEB-SERVICE设置.docx
11-29
Endpoint 是 WEB SERVICE 的入口点，用于接受和处理来自外部的请求。 在 SE80 中创建 Service Consumer 在 SAP ECC 6 中，Service Consumer 是 WEB SERVICE 的客户端。在 SE80 中，可以创建 Service Consumer，并...
南开大学复习资料-Web页面设计.docx
最新发布
12-17
* CSS 中，外部样式表是一个独立的样式表文件，保存在本地站点中，能够应用在当前的文档中，也可以应用在其他的网页文档中，或者整个站点中应用。 五、Flash * Flash 中的遮罩层的基本原理是能够透过该图层的对象...
Web前端开发工程师笔试题-CSS+Javascript.doc
12-14
1. CSS样式表的分类：行内样式表、内嵌样式表、外部样式表 2. CSS样式属性：border、background-color、text-decoration等 3. CSS选择符：标签选择符、类选择符、ID选择符 4. CSS样式表的引入方式：link引入、import...
《Java-Web应用开发基础》综合练习4.docx
12-17
_Java-Web应用开发基础_综合练习4.docx 《Java-Web应用开发基础》综合练习4.docx中涵盖了多个IT相关知识点，以下是对标题、描述、标签和部分内容的详细说明： 1. B/S结构和C/S结构的区别 B/S结构（Browser/Server...
vue-web-component-wrapper:将Vue组件包装为Web组件自定义元素
05-02
，因为它不像Shadow DOM那样提供真实的样式封装，因此外部样式表可能会影响您的组件。使用散列的类名。 如果定位不支持ES2015的浏览器： 您可能需要重新考虑，因为在这种情况下最好不要使用Web组件。用法dist/vue-...
Greenplum管理索引
Gtlions Tracker
04-24 6269
鉴于OLAP系统的特性，应该谨慎并保守地使用索引。避免在频繁更新的列上使用索引；在高选择性的列上使用B-tree索引；在低选择性的列上使用Bitmap索引。 通常来说在传统数据库中使用索引可以有效的提高数据访问效率，特别是在OLTP系统中，往往只是需要从大表中获取几行或者部分的数据记录，这个情况下索引确实是特别有效的提高数据获取速度的方法。但是在gp中未必如此，因为首先数据都是均匀最大可能的均匀
idle in transaction
Gtlions Tracker
11-25 4314
检查库的时候发现有8个超过17个小时的会话，执行状态为 idle in transaction。 从文档上可以看到解释： idle in transaction (waiting for client inside a BEGIN block) 通知开发提交或者回滚，抑或杀之。 -EOF-
Greenplum管理表空间Tablespace
Gtlions Tracker
04-19 3530
create tablespace gtlions_ts1 [owner gtlions] filespace gtlionsfilespace; alter tablespace gtlions_ts1 rename to gtlions_ts2; alter tablespace gtlions_ts1 owner to gtlions; 表空间是基于文件空间filespace的，实
修改gp集群主机名称
Gtlions Tracker
12-29 3446
在某些情况下，特别是在前期没规划好的情况下，后期运行过程中会遇到需要修改hostname&ip的情况，现状遇到的情况是需要调整hostname，对于某些已经投产或者的集群类的环境，修改这些信息尤为麻烦。 大体步骤： 0. 维护模式打开数据库，修改配置表 gp_segment_configuration 的hostname和address字段为新主机名称； 1、停库，关闭维护模式； 2、修改
SQLSTATE58030
Gtlions Tracker
12-02 3308
在优化一条SQL的时候遇到了执行错误 gtlions =# select t1.telnumber,t2.ua,t2.url,t1.apply_name,t2.apply_name from tb1 t1 gtlions -# left outer join tb2 t2 on t1.sid = t2.ipsid gtlions-# where t1.sum_date=20141128 a
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值