Hi all, for host hanasvr-05 and userid -  P1121834, unable to query table FTP_server as it does not exist under the SYSTEM schema. Could someone help?

Edited by: vinsapbw on Feb 14, 2012 10:01 AM

Edited by: vinsapbw on Feb 14, 2012 12:40 PM

Thanks. It returns a value today.

Hi Venkatesh,

Thanks for the response. I was doing the same but it was not returning a value until today.

Regards,

Kumud

Was resolved by inmemorydevcenter. thanks.

Alvaro: thanks - I wish I had read this blog earlier - spent a lot of time late night figuring things out...in SP3...

Good stuff guys.. thanks...

.As part of building my custom model...I figured out the below SQL  syntax to use dates within SAP HANA tables. Wanted to share with you all:

*Creating HANA tables with  date and time columns(syntax below):*

Create column table xxx.sales_fact_rs

(region_id integer, item_id integer, sales_amount double, order_dt TIMESTAMP,  delivery_dt TIMESTAMP);

Inserting dates into HANA tables (syntax below):

Insert into xxx.sales_fact_rs values

(1,6,100,

'2011-02-01 17:07:10',

'2011-02-02 17:07:10');

Also refer to other date and time options supported by HANA in the " SAP HANA DB - SQL Reference Guide-011000358700000604922011.pdf page#14"

Enjoy working in HANA Guys !

Cheers!

[Click her to review SAP HANA & SAP HANA research summary|http://www.sendspace.com/filegroup/smbF3Mp4YMSL7vTk%2F9lhjg]

hi Kumud/Alvaro,

Are you working on SRV-04, because i am unable to load data into my tables.

i have created my folder 'PANDEYD' in the dropbox folder.

my sql command is as follows:

import from '/dropbox/dropbox/PANDEYD/abc.ctl'

but  i am get "cannot open file " error.

is there any problem with srv-04?

because the same is running fine on SRV-03.

thanks

Edited by: Mrityunjay on Feb 26, 2012 7:36 PM

hello,

Import statements are working on both hanasvr-03 and hanasvr-04 . I was able to import successfully . I didn't find any issues. here.

Regards,

KrishnaTangudu

Ronald,

This link really helped a lot in real time ...Good Job

Thanks

Balaji Karunakaran

Hi,

I am on hana server 7:  hanasvr-07 00

I have been following the NASDAQ guide from the wiki. I retrieved the data from infochimps and uploaded it to the folders:

/S0004092614 and  /dropbox/S0004092614

I tried following the various guides for importing the data; i continuously keep getting the error. I followed the guide posted here:

http://scn.sap.com/people/r.konijnenburg/blog/2011/12/26/sap-hana-developer-access-beta-program--get-the-best-out-of-your-test-drive

I then followed the guide for the table for USERS in this guide:

http://wiki.sdn.sap.com/wiki/display/inmemory/Importing+CSV+files+into+SAP+HANA

It still gives an error:
SAP DBTech JDBC: [2]: general error: Cannot open Control file, /dropbox/S00040926142/USERS.CTL

No error log is generated either .Am i missing something?

Hi,

same for me

loaded data to

P1343556667

and want to run on hanasvr-07

IMPORT FROM '/dropbox/P1343556667/gutenberg.ctl'

But get

Could not execute 'IMPORT FROM '/dropbox/P1343556667/gutenberg.ctl''

SAP DBTech JDBC: [2] (at 34): general error: Cannot open Control file, /dropbox/P1343556667/gutenberg.ctl

Can someone check this?

Is solved - the issue was the filezilla created the new dir with 766 permission but 755 is required

Hi All,

we tried to upload .csv file into HANA Table.

"it is executed successfully  with 0 rows  affcted". we were unable to find where the problem persist.

Please help us.

Thanks in advance.

Phani

Please help.

Having same issue with control file ...tried everything so far suggested in the threads on this very question. Thanks in advance,

IMPORT FROM '/dropbox/S0000384916/NYSE.ctl'

SAP DBTech JDBC: [2] (at 13): general error: Cannot open Control file, /dropbox/S0000384916/NYSE.ctl

Could not execute 'Import from '/dropbox/S0000384916/NYSE.ctl''