44582

Teradata / Aster : Fast Export / ncluster_export using query

Question:

I am trying to export a query from Teradata Studio 14.10 / Aster using the ncluster_export command line function. I can't find a working example to go off of. Does anyone have one they could share? Also how would I actually run the script (ie ncluster_export myScript1.bat)?

Assume the following :

File location: 'myhomedir' Username: 'user1' Password: 'pass1' Outfile name: 'outFile1.csv'

Answer1:

If you want to export a result set from Teradata Studio then you can do that from the "Teradata Result Set Viewer" window. There's an export icon on the top right corner.

If you want to run a SQL script then export the results to a file then you should use ACT rather than ncluster_export

The syntax is -

act -h QueenIPaddress -U user1 -w pass1 -f myscript.sql -o $myhomedir/outFile.csv -F ','

This will pass a SQL script to Aster and redirect the output to the specified file. The -F parameter specifies the delimiter.

There are other parameters you can use. act --help will list them

Answer2:

I can't test it right now, but I don't think you can use a ncluster_export directly within TD Studio, you need to run it on your PC's command line.

Did you install the Aster Client Tools on your PC running TD Studio?

Then it should be (you seem to be on Windows):

<ul><li>start the command line (cmd) and enter</li> <li>cd myhomedir</li> <li>ncluster_export --hostname ip_of_asterqueen --username user1 --password pass1 --csv schemaname.tablename outFile1.csv</li> </ul>

Regarding running the script, you can't pass the parameters to cluster_export (afaik) in a file, but you can put the commands in a <em>bat</em>-file and then execute this.

Recommend

  • Pipe filehandle to fork of self
  • GNU parallel: output each job to a different file without pipes
  • How do I get my code to check for valid username and password combination?
  • Create objects in for loop
  • argparse doesn't check for positional arguments
  • Customizing the specific output files for various Typescript input files
  • insert into a MySQL database on a different server
  • Git cherry-Pick a batch of commits from a file
  • Uploading file with WCF streaming, tiny reads from stream
  • MonoTouch Dialog. Buttons with the Elements API
  • Socket io in node app on google app engine
  • How to remove comma or any characters from Python dataframe column name
  • SSH in Bash Script Messing Up File Read
  • Submit a form with jQuery / Javascript without ignoring “required” tag
  • It is possible use the same sql azure instance from two different cloud service of two different sub
  • How can I sync the html/session used between Django's 'Client' and Selenium's we
  • How to assert that an input element is empty in Ruby on Rails tests
  • Retrofit SocketTimeoutException (and/or http 500 error) on http-POST
  • SqlCommand back up Database
  • (Tcl/Expect) clear screen after exit
  • Tomcat memory Leak
  • Login not working in Firefox in Meteor
  • Authentication in Play! and RestEasy
  • Textfile Structure (tables)
  • MongoError: Incorrect arguments
  • Django rest serializer Breaks when data exists
  • How to redirect a user to a different server and include HTTP basic authentication credentials?
  • php design question - will a Helper help here?
  • using conditional logic : check if record exists; if it does, update it, if not, create it
  • AngularJs get employee from factory
  • Codeigniter doesn't let me update entry, because some fields must be unique
  • Getting error when using KSoap library to consume .NET web services
  • How to set the response of a form post action to a iframe source?
  • Change div Background jquery
  • Qt: Run a script BEFORE make
  • IndexOutOfRangeException on multidimensional array despite using GetLength check
  • Authorize attributes not working in MVC 4
  • Can't mass-assign protected attributes when import data from csv file
  • reshape alternating columns in less time and using less memory
  • UserPrincipal.Current returns apppool on IIS