on 02-12-2014 7:57 AM
Hello Everyone,
I have some questions related to SAP HANA Studio.
1) How to change Max rows from 200 to 5000 in Data Preview?
2) While creating graphical calculation views, I could not add more than two tables in "join", "union" operations.
How can I add more than two tables or views in "join", "union" operations?
3) In SAP Hana Studio and modeler view, we have an element called ‘Projection’ (join, union, aggregation of calculation view).
When working with ‘Projection’, I can only add two objects(joins, unions etc) to it.
Why only two objects allowed? How can I add more than two objects to ‘Projection’?
4) How can I change the data type of a table column in model views(Attribute/Analytic/Calculation)?
5) Is it possible to change the data type of a table column? How?
6) Is there a way to create two index tables on one and the same column of a table?
7) In SAP HANA Studio, how to create outer joins on two different tables using SQL queries?
Please help me in resolving the above queries.
in HANA Studio,
Click on Window -> Preferences -> SAP HANA -> Modeler -> Data Preview
and then select "No Limit" (might lead to memory issues when previewing large tables)
You can only select 5000 or no limit depending on your need
Thanks,
Sundeep
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
So you really need to go on a training course for SAP HANA - this will all be covered. Alternatively it is all in the HANA documentation in http://help.sap.com/hana
1) Preferences -> SAP HANA -> Runtime -> Result -> Maximum number of rows displayed in result
2) This is by design. You can use a Star Join as of Rev.70 in the output node for multiple tables.
3) This is by design.
4) By changing the data type of the underlying table or creating a calculated column.
5) ALTER TABLE <TABLENAME> ALTER (<COLUMNNAME> <NEWTYPE>)
6) This question doesn't make any sense
7) Yes, using SQL or SQLScript
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi John and Krishna,
Thank you for your replies.
1) "Preferences -> SAP HANA -> Runtime -> Result -> Maximum number of rows displayed in result" is not working for me. Though, I change it to 5000 in the Preferences/Modeler, it still shows Max rows as 200 and I have to manually change it to 5000 every time.
2) Please let me know the solution for Rev.60.
3) I am not sure if it is a design problem.
4) I have tried to change the data type of a table column in calculation view. It did not work for me.
5) I have tried to changed the data type with the above provided syntax. It does not allow me to convert NVARCHAR to DECIMAL.
6) Could you please let me know why creating two index tables on a single column makes no sense to you(John)?
7) Even I am aware outer joins can be done using SQL queries. However, I am looking for some example SQL queries.
1) Works here. Try updating your HANA Studio revision.
2) Upgrade to Revision 70 or link the joins together in multiple steps.
3) It's just how it works, link multiple projections together in multiple steps.
4) You can't change the data type of a column in a calculation view unless you create a calculated column. Even then you can't convert between text and numeric.
5) You cannot convert from NVARCHAR to DECIMAL, you have to create a new column and then update the new column, casting from NVARCHAR to DECIMAL using to_decimal. This is the same as other SQL databases.
ALTER TABLE <TABLENAME> ADD <COLUMNNAME> DECIMAL(17,2);
UPDATE <TABLEMAME> SET <COLUMNDECIMAL> = to_decimal(<COLUMNTEXT>);
In general, be sure to use the right structured column types in the first place with HANA. It's very important to the design and performance of your applications.
6) The sentence doesn't parse. Since it doesn't parse I have no idea what you're asking.
7) There are plenty of SQL examples to be found if you search Google or SCN.
User | Count |
---|---|
87 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.