精华内容
下载资源
问答
  • TeraData

    2020-06-29 10:50:35
    ( Basic Teradata Query ) .SET DEFAULTS:将输出格式定义成默认值; .SET ECHOREQ ON/OFF:是否将SQL请求及BTEQ命令复制到输出报表中; .SET FOLDLINE ON 1:把第1个字段显示在第1行,其它字段的值显示在第2行; ...

    bdeq <<!

    ( Basic Teradata Query )

    .SET DEFAULTS:将输出格式定义成默认值;
    .SET ECHOREQ ON/OFF:是否将SQL请求及BTEQ命令复制到输出报表中;
    .SET FOLDLINE ON 1:把第1个字段显示在第1行,其它字段的值显示在第2行;
    .SET FOOTING [NULL,‘string’]:定义脚注,可以包含&DATE、&TIME、&PAGE、&n;
    .SET FORMAT ON/OFF:当设置OFF时,BTEQ将忽略FOOTING、FORMCHAR、RTITLE、HEADING、PAGEBREAK等的设置;
    .SET HEADING [NULL,‘string’]:定义页头,使用同FOOTING一样;
    .SET NULL AS ‘string’:对于NULL,默认值为问号,可以改变它的缺省值;
    .SET OMIT ON/OFF [,/n/ALL]:将指定的字段不包括在报表中,它们可能用于在页头、脚注中;
    .SET PAGEBREAK ON/OFF [,/n/ALL]:当指定的字段的值发生变化时,插入一个分页符,开始新的一页;
    .SET PAGELENGTH n:定义页面的长度,默认值为55行;
    .SET RTITLE [‘string’]:定义每页上方的标题,它将自动包含日期和页号;
    .SET SEPARATOR [‘string’/n]:定义字段之间的分隔符,用n表示空格;
    .SET SUPPRESS ON/OFF [,/n/ALL]:对指定的字段,如果遇到有连续重复的值,则用空格代替;
    .SET SKIPLINE ON/OFF [,/n/ALL]:当指定字段的值发生变化时,则插入一个空行;
    .SET SKIPDOUBLE ON/OFF [,/n/ALL]:当指定字段的值发生变化时,则插入两个空行;
    .SET UNDERLINE ON/OFF [,/n/ALL]:在每行输出中对指定的字段加下划线;
    .SET WIDTH n:设置报表的宽度,默认值为75;
    .EXPORT DATA FILE="/datashare/dataops/cronjob/dbctables_mztlvs" 输出到文件
    .EXPORT RESET; 恢复标准输出
    .SET RECORDMODE OFF; 记录模式

    展开全文
  • Teradata

    2017-08-21 17:56:00
    Teradata 安装 参考https://www.w3cschool.cn/teradata/teradata_installation.html 去官网下载 对应虚拟机版本。 1 :成功启动后,以 root 身份输入用户名,用户名及密码均为”root“。 2:虚拟机系统界面如下...

    Teradata 安装

    参考 https://www.w3cschool.cn/teradata/teradata_installation.html

    去官网下载 对应虚拟机版本。

    1 :成功启动后,以 root 身份输入用户名,用户名及密码均为”root“。 

    2:虚拟机系统界面如下图所示,双击”Gnome Terminal“或单击鼠标右键,选择”Open in Terminal“,打开shell。 

    3:在shell中,输入命令“/etc/init.d/tpa start”+ Enter,启动Teradata服务器。

     

     

    数据库客户端

    BTEQ 实用程序用于交互提交 SQL 查询。

    步骤1:输入命令 “ifconfig”,记下 VMWare 的 IP 地址。

    步骤2:输入命令“bteq”,运行 BTEQ。

    步骤3:输入命令“logon 192.168.11.104/dbc;”+Enter,在 Password 处输入 “dbc”+ Enter,登陆 BTEQ。

    转载于:https://www.cnblogs.com/psy5choit/p/7405863.html

    展开全文
  • teradata

    2008-06-15 17:57:08
    teradata教程
  • 如题,公司原本是用teradata sql assistant的,但我用着实在不习惯就安装了个dbeaver。然后查询结果是中文的就都是乱码!查询网上的更改java环境变量也试了,并没什么用,如图,应该怎么处理,或者怎么查看数据库的...
  • TeraData-源码

    2021-03-13 08:00:30
    TeraData
  • TERADATA学习

    2018-05-17 17:46:53
    深入的介绍了teradata的数据库以及原理,并提供了teradata sql语句的学习资料,资料很基础,也比较深入
  • Teradata SQL

    2017-10-24 21:55:59
    Teradata SQL 基础教程 第一章 关系数据库基础 第二章 TERADATA SQL 基础 第三章 数据库试验环境 第四章 帮助系统 第五章 逻辑与条件表达式、 第六章 数据转换和计算 第七章 简单的宏 。。。
  • teradata jdbc 下载

    2020-11-04 18:03:45
    Teradata是全国数一数二的专注于大数据方向的公司,提供Teradata数据仓库服务 版本:terajdbc4.jar teradata jdbc 下载
  • Teradata for Node.js 特征 异步 读/写 准备的陈述 连接池 活着 安装 npm install node-teradata Java node-teradata使用JDBC与Teradata进行通信: 下载并安装JDK 8( ) 确保系统路径中包含Java 其他版本的JDK...
  • Teradata基础教程

    2018-01-17 10:36:12
    Teradata基础教程Teradata基础教程Teradata基础教程Teradata基础教程Teradata基础教程
  • teradata16

    2019-03-31 22:11:31
    teradata16,虚拟机,下载后Vmware可直接打开玩td数据库
  • teradata master

    2015-03-30 16:26:23
    teradata master v2r5,
  • I have installed python 2.7.0 and Teradata module on Windows 7. I am not able to connect and query TD from python.pip install TeradataNow I want to import teradata module in my source code and perform...

    I have installed python 2.7.0 and Teradata module on Windows 7. I am not able to connect and query TD from python.

    pip install Teradata

    Now I want to import teradata module in my source code and perform operations like -

    Firing queries to teradata and get result set.

    Check if connection is made to teradata.

    Please help me writing code for the same as I am new to Python and there is no information available with me to connect to teradata.

    解决方案

    There are a number of ways to connect to Teradata and export table to Pandas. Here are four+:

    # You can install teradata via PIP: pip install teradata

    # to get a list of your odbc drivers names, you could do: teradata.tdodbc.drivers

    # You don’t need to install teradata odbc driver if using method='rest'.

    # See sending data from df to teradata for connection example

    import teradata

    import pandas as pd

    host,username,password = 'HOST','UID', 'PWD'

    #Make a connection

    udaExec = teradata.UdaExec (appName="test", version="1.0", logConsole=False)

    with udaExec.connect(method="odbc",system=host, username=username,

    password=password, driver="DRIVERNAME") as connect:

    query = "SELECT * FROM DATABASEX.TABLENAMEX;"

    #Reading query to df

    df = pd.read_sql(query,connect)

    # do something with df,e.g.

    print(df.head()) #to see the first 5 rows

    from @ymzkala : This package doesn't require you to install Teradata drivers (other than this package).

    # Installing python -m pip install teradatasql

    import teradatasql

    with teradatasql.connect(host='host', user='username', password='password') as connect:

    df = pd.read_sql(query, connect)

    import pyodbc

    #You can install teradata via PIP: pip install pyodbc

    #to get a list of your odbc drivers names, you could do: pyodbc.drivers()

    #Make a connection

    link = 'DRIVER={DRIVERNAME};DBCNAME={hostname};UID={uid};PWD={pwd}'.format(

    DRIVERNAME=DRIVERNAME,hostname=hostname,

    uid=username, pwd=password)

    with pyodbc.connect(link,autocommit=True) as connect:

    #Reading query to df

    df = pd.read_sql(query,connect)

    #You can install sqlalchemy via PIP: pip install sqlalchemy-teradata

    #Note: It is not pip install sqlalchemy. If you already have sqlalchemy, you still need sqlalchemy-teradata to get teradata dialects

    from sqlalchemy import create_engine

    #Make a connection

    link = 'teradata://{username}:{password}@{hostname}/?driver={DRIVERNAME}'.format(

    username=username,hostname=hostname,DRIVERNAME=DRIVERNAME)

    with create_engine(link) as connect:

    #Reading query to df

    df = pd.read_sql(query,connect)

    There is a fifth way, using giraffez module. I enjoy using this module as it come with MLOAD, FASTLOAD, BULKEXPORT etc. The only issue for beginners is its requirements (e.g C/C++ compiler ,Teradata CLIv2 and TPT API headers/lib files).

    Note: Updated 13-07-2018, using of context manager to ensure closing of sessions

    Update: 31-10-2018: Using teradata to send data from df to teradata

    We can send data from df to Teradata. Avoiding 'odbc' 1 MB limit and odbc driver dependency, we can use 'rest' method. We need host ip_address, instead of driver argument. NB: The order of columns in df should match the order of columns in Teradata table.

    import teradata

    import pandas as pd

    # HOST_IP can be found by executing *>>nslookup viewpoint* or *ping viewpoint*

    udaExec = teradata.UdaExec (appName="test", version="1.0", logConsole=False)

    with udaExec.connect(method="rest",system="DBName", username="UserName",

    password="Password", host="HOST_IP_ADDRESS") as connect:

    data = [tuple(x) for x in df.to_records(index=False)]

    connect.executemany("INSERT INTO DATABASE.TABLEWITH5COL values(?,?,?,?,?)",data,batch=True)

    Using 'odbc', you have to chunk your data to less than 1MB chunks to avoid "[HY001][Teradata][ODBC Teradata Driver] Memory allocation error" error: E.g.

    import teradata

    import pandas as pd

    import numpy as np

    udaExec = teradata.UdaExec (appName="test", version="1.0", logConsole=False)

    with udaExec.connect(method="odbc",system="DBName", username="UserName",

    password="Password", driver="DriverName") as connect:

    #We can divide our huge_df to small chuncks. E.g. 100 churchs

    chunks_df = np.array_split(huge_df, 100)

    #Import chuncks to Teradata

    for i,_ in enumerate(chunks_df):

    data = [tuple(x) for x in chuncks_df[i].to_records(index=False)]

    connect.executemany("INSERT INTO DATABASE.TABLEWITH5COL values(?,?,?,?,?)",data,batch=True)

    展开全文
  • teradata.zip

    2019-12-04 10:14:40
    teradata驱动jar terajdbc4-14.00.00.37.jar 和 tdgssconfig-14.00.00.37.jar,java连接teradata需要这两个jar
  • Teradata SQL Advanced

    2017-07-10 11:29:22
    Teradata SQL Advanced
  • teradata数据库

    2010-08-10 15:17:15
    teradata 学习文档 teradata 学习文档 teradata 学习文档 teradata 学习文档 teradata 学习文档 teradata 学习文档
  • teradata design

    2013-03-23 17:37:15
    Teradata Database Design,英文版,讲述Teradata数据库的架构和原理,共17个章节,非扫描版
  • teradata基础知识

    2018-07-13 19:02:02
    teradata基础 ,详细的介绍了teradata体系结构,学习teradata不错的资料
  • Teradata Database

    2009-04-20 22:32:42
    Teradata SQL基础教程 Teradata
  • teradata Java Driver

    2017-08-24 15:07:00
    teradata Java Driver tdgssconfig.jar,terajdbc4.jar
  • Teradata Python Module

    2016-07-04 16:55:08
    python连接Teradata的插件
  • Teradata语法迁移到elk

    2018-06-05 17:59:07
    Teradata语法迁移Teradata语法迁移Teradata语法迁移Teradata语法迁移Teradata语法迁移

空空如也

空空如也

1 2 3 4 5 ... 20
收藏数 7,568
精华内容 3,027
关键字:

teradata