Netezza: While creating external table, column name is duped with same data type, need to know the reason -

-

i creating external table in netezza. after table creation when describing it, can see column duped 4 times. looks strange me happening.

example:

    create external table test '/nzscratch/kapish/69314.082.000/tv_daily_audit_results.txt'             using(delim '|' format 'text'            )     select         b.card_acceptor_id mid,         a.div_no card_div_no,         c.div_name acct_type,         a.acct_id,         a.tran_text,         substr(a.tran_text, 24, 13) merchant_city,         substr(a.tran_text, 37, 2) merchant_state,         b.merchant_zip_cd,         a.post_date,         a.tran_cd,         a.gl_origin_cd,         a.tran_amt,         a.merchant_cat_cd             pstdtr_pstd_trans a,         pstdrt_rtain_rtns b,         divdef_div_def_v c             a.acct_id = b.acct_id         , a.reference_no = b.reference_no         , a.tran_date = b.tran_date         , a.div_no = c.div_no         , a.div_no in (232, 234, 235, 237, 273, 275, 276, 278)         , post_date >= (current_date - 2)         , gl_origin_cd not in (232, 234, 235, 237, 273, 275, 276, 278)      system.admin(admin)=> \d test        external table "tv_daily_audit_results"     attribute    |         type          | modifier -----------------+-----------------------+----------  mid             | character(15)         |  mid             | character(15)         |  mid             | character(15)         |  mid             | character(15)         |  card_div_no     | smallint              | not null  card_div_no     | smallint              | not null  card_div_no     | smallint              | not null  card_div_no     | smallint              | not null  acct_type       | character(30)         |  ..  ..  ..  merchant_cat_cd | integer               |  merchant_cat_cd | integer               |  merchant_cat_cd | integer               |  merchant_cat_cd | integer               |  dataobject - 'c:\winsql jobs\daily tv audit\tv_daily_audit_results.txt'  dataobject - 'c:\winsql jobs\daily tv audit\tv_daily_audit_results.txt'  dataobject - 'c:\winsql jobs\daily tv audit\tv_daily_audit_results.txt'  dataobject - 'c:\winsql jobs\daily tv audit\tv_daily_audit_results.txt'  adjustdistzeroint   -  bool style          - 1_0 .  .  decimaldelim        -  disablenfc          -  includeheader       -

now sure reason it. if 1 can me, great.

this appears same bug/issue recognized in this question, has been resolved subsequent fixes/releases. should contact support fix.

the table should function normal, despite odd report catalog.


Comments

Post a Comment

Popular posts from this blog

javascript - Karma not able to start PhantomJS on Windows - Error: spawn UNKNOWN -

-
i lost "unknown" error: karma.conf.js: frameworks: ['mocha', 'should'], plugins: ['karma-mocha', 'karma-should', 'karma-phantomjs-launcher'], ... browsers: ['phantomjs'], error: 23 07 2015 14:35:37.691:warn [karma]: no captured browser, open http://localhost:9876/ 23 07 2015 14:35:37.701:info [karma]: karma v0.13.3 server started @ http://localhost:9876/ 23 07 2015 14:35:37.707:info [launcher]: starting browser phantomjs 23 07 2015 14:35:37.738:error [karma]: { [error: spawn unknown] code: 'unknown', errno: 'unknown', syscall: 'spawn' } error: spawn unknown @ exports._errnoexception (util.js:749:11) @ childprocess.spawn (child_process.js:1093:11) @ exports.spawn (child_process.js:933:9) @ object._execcommand (c:\users\jinga4x\git\mdl-sample-project\node_modules\karma\lib\launchers\process.js:63:21) @ object._start (c:\users\jinga4x\git\md
Read more

Nuget pack csproj using nuspec -

-
i want create nuget package contains specified in nuspec file, still version csproj. in order use token have pack like: nuget pack myproj.csproj but when adds dependencies , creates unwanted folder in nuget package. nuspec file is: <?xml version="1.0" encoding="utf-8"?> <package xmlns="http://schemas.microsoft.com/packaging/2011/08/nuspec.xsd"> <metadata> <id>test</id> <version>$version$</version> <title>test</title> <authors>test</authors> <owners>test</owners> <requirelicenseacceptance>false</requirelicenseacceptance> <description>test</description> <summary>test</summary> <releasenotes>test</releasenotes> <copyright>test</copyright> </metadata> <files> <file src="bin\debug\*.dll" target="lib\net45" /> <file s
Read more

c# - Display ASPX Popup control in RowDeleteing Event (ASPX Gridview) -

-
i have aspxgridview includes new , delete button. delete button includs gv_rowdeleting event. want show aspxpopupcontrol (id="pupconfirm"). want user have confirm password delete item. tried: protected void gv_rowdeleting(object sender, devexpress.web.data.aspxdatadeletingeventargs e) { pupconfirm.showonpageload = true; } but nothing happened. please me. !!! you can create template column javascript prompt confirmation. <itemtemplate> <asp:linkbutton id="btndelete" runat="server" text="delete" commandname="delete" onclientclick="javascript:if(!confirm('are sure want delete record?')){return false;}"> </asp:linkbutton> </itemtemplate>
Read more