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
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 !
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.
Edited by: Mrityunjay on Feb 26, 2012 7:36 PM
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:
I then followed the guide for the table for USERS in this guide:
It still gives an error:
SAP DBTech JDBC: : general error: Cannot open Control file, /dropbox/S00040926142/USERS.CTL
No error log is generated either .Am i missing something?
same for me
loaded data to
and want to run on hanasvr-07
IMPORT FROM '/dropbox/P1343556667/gutenberg.ctl'
Could not execute 'IMPORT FROM '/dropbox/P1343556667/gutenberg.ctl''
SAP DBTech JDBC:  (at 34): general error: Cannot open Control file, /dropbox/P1343556667/gutenberg.ctl
Can someone check this?
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:  (at 13): general error: Cannot open Control file, /dropbox/S0000384916/NYSE.ctl
Could not execute 'Import from '/dropbox/S0000384916/NYSE.ctl''