I am trying to join 2 tables but my problem is that one of the table has 10 digit number and the other one may have 10 or less digit number. For this reason, i am loosing some data so i would like ...

I am currently writing a script to run multiple SQL files using Python, a little background before you mention alternative methods; this is to automate the scripts and Python is the only tools I ha...

I have a source as XML and has a huge number of records. just for the sample I have pasted 1 record below : <?xml version='1.0' encoding='UTF-8'?><wd:Report_Data xmlns:wd="urn:com.wor...

Netezza sql is giving error on this query:Cause: Invalid column name 'dummy'. select col1,col2, '' as dummy, max(col3) from table1 group by col1,col2,dummy If i remove the dummy from the group ...

I'm in the process of converting Python code over to the new SQLAlchemy-based Pandas 0.14.1. A common pattern we use is (generically): connection = db.connect() # open connection/session sql = '...

After connecting to a Netezza system is there any way to switch the database? For instance, in MSSQL one could send the command use database_name in order to switch to the database_name. Is there ...

I set up an ODBC connect to a Netezza (SQL database). The connection is fine. However, R only pulls out 256 rows by default and restricts the number of rows it can pull out. If I ran the query in...

I have two tables. One is a Reference table, used to sort priority, and one is a Customer table. The Reference table is used to give priority to each column in the Customer table, to give a differe...

Is there a query I can write to search all the column names for a particular database in Netezza?

I am trying to write an R data.frame to a Netezza table. It has about 55K rows and I have set 4GB as memory limit for Java (options(java.parameters = "-Xmx4096m")) Query: insert into MY_TABLE_NAM...

I am creating an external table as shown below CREATE EXTERNAL TABLE '~\test.csv' USING ( DELIMITER ',' Y2BASE 2000 ENCODING 'internal' REMOTESOURCE 'ODBC' ESCAPECHAR '\' ) AS SELECT * FROM TEST...

So. This issue is almost exactly the same as the one discussed here -- but the fix (such as it is) discussed in that post doesn't fix things for me. I'm trying to use Python 2.7.5 and pyodbc 3.0....

In oracle, if the other database is within the same server, I did the following to create a synonym CREATE SYNONYM synonymName FOR databaseName.schema.table; What should I do to create a synonym...

I need to find a table size on IBM netezza sql database from Aginity workbench on win 7. I used this SELECT * FROM _V_TABLE where tablename = 'my_table_name' But, no information about table ...

I have a bitmap stored as a VARCHAR in Netteza. Need to convert that VARCHAR to a binary string in Netezza. Input (Netezza col value - VARCHAR ) = '0xFFFFFFFFFFFFFFFF' Desired output (VARCHAR)-> ...

Im unable to replace an special character. Could you please help me on this. my input is: Mrs঩Montero output should be: Mrs Montero Special character is not displaying correctly. please s...

I have a list of tables in a Netezza database and I want to get the name of primary key for each of the tables. Can anyone provide me the query.

How do I convert date in Netezza to yyyymmdd from timestamp format?

Want to understand whether Netezza or Hadoop is the right choice for the below purposes: Pull feed files from several online sources of considerable size at times more than a GB. Clean, filter, t...

I am new to SQL and have been searching for a way to set variables in ANSI SQL. I have this: select * from table1 where first_date > '2014-01-01' and where second_date = '2014-01-01' and where t...

This is my query that does not work in Netezza: UPDATE TABLE1 A SET A.COL1= (SELECT DISTINCT B.COL1 FROM TABLE2 B WHERE B.ID= A.ID AND B.DeptID=104) WHERE A.DeptID=3 How do I re-write this query...

I want to run a basic query, but return only the first ten rows of the table from Netezza select a.* from some_schema.some_table a where rownum < 10 What is the Netezza way of looking at ju...

This should be doable, but how can I extract the day of the week from a field containing data in date format with Netezza SQL? I can write the following query: SELECT date_part('day',a.report_dt) ...

In Netezza, if I do: SELECT * FROM Tbl order by col1 LIMIT 10 OFFSET 20; First of all, what is OFFSET 20. And also, will this give me the first 10 rows specified in the order by or will the o...

Why can't .NET connect to my Netezza box via the installed {NetezzaSQL} driver? 64bit applications also cannot connect via this ODBC connection. Why would that be? I've built both user and system N...