HI gayan, Can you explain your requirement in detail?
If you wanted to do some admin related summarizing tasks, then you need to publish the tenant related information along with tenant domain, etc to the super-admin space using the super-admin credentials and then run the summarization as super-admin for tenant. This is how we do in the logging, usage-metering, etc. If you want to publish the data to tenant space, then of course you need to know the tenant credentials to summarize. You may also use the cassandra datasource name in the hive script, it that case you can generalize the hive script for tenants but the tenant need to create that data source for the successful execution of the script. Thanks, Sinthuja. On Mon, Jul 15, 2013 at 12:02 PM, Gayan Dhanushka <[email protected]> wrote: > > Hi all, > > Is there a way we can do $subject? > > In the example given in the documentation I can see that cassandra > keyspace credentials have been hard coded. For each tenant the credentials > would be different. So how can we provide it during runtime? > > *CREATE EXTERNAL TABLE IF NOT EXISTS PhoneSalesTable > (orderID STRING, brandName STRING, userName STRING, quantity INT, > version STRING) STORED BY > 'org.apache.hadoop.hive.cassandra.CassandraStorageHandler' > WITH SERDEPROPERTIES ( > "cassandra.host" = "127.0.0.1" ,"cassandra.port" = "9160" , > "cassandra.ks.name" = "EVENT_KS" ,"cassandra.ks.username" = > "[email protected]" , > "cassandra.ks.password" = "sinthuadmin" , > "cassandra.cf.name" = "org_wso2_bam_phone_retail_store_kpi" , > "cassandra.columns.mapping" = > ":key,payload_brand, payload_user, payload_quantity, Version" );* > > > Thanks > > > Gayan > > -- > > Gayan Dhanushka > Software Engineer > WSO2 Inc. > http://wso2.com > > Mobile : 0716662327 > -- *Sinthuja Rajendran* Software Engineer <http://wso2.com/> WSO2, Inc.:http://wso2.com Blog: http://sinthu-rajan.blogspot.com/ Mobile: +94774273955
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
