ST Alpha - "It is a simple select." (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Down to Post

Backboards:

Posts: 152

In response to "what is the query that causes that error? -- nm" by Beryllium

It is a simple select.

Posted by GregW (aka not2fast) Aug 23 '12, 15:05

There are only 2 columns in the table. They key is varchar(22) and the other column is varchar(255). I just execute "select c1, c2 from table order by c1".

Responses:

and what do you want to do with it? -- nm - Beryllium Aug 23, 15:09 5
- I am running a tool that extracts the data to my DB2 server where I will use it to load our new database. - GregW Aug 23, 15:14 4
  - Really? It doesn't use disk files for sorting? -- nm - GregW Aug 23, 15:21 1
    - mysql might - but since you're invoking it from java, I think it's trying to create an in-memory result set that is too large -- nm - Beryllium Aug 23, 15:22
  - You might want to forget java and just use mysqldump ... or even the mysql command itself to make a CSV -- (link) - Beryllium Aug 23, 15:19
  - well, it sounds like what you're telling it to do is "select 200 million rows into RAM", which ... isn't useful. -- nm - Beryllium Aug 23, 15:17

Post a message top

It is a simple select.

Replies are disabled on threads older than 7 days.