VanyaC

You can try the following: <bean class="com.jaspersoft.ji.adhoc.strategy.AggregateConfig"> <property name="name" value="DistinctCount"/> <property name="functionName" value="distinctCount"/> <!-- distinct count not currently mapped directly to sql func --> <property name="calcMethod" value="sqlGroupBy"/>

JasperReport supports HIVE2 connection. And it should be able to connect other than default databse in up coming version. Are you trying to connect through Jaspersoft studio or JasperReport Server? And which version are you using?

What do u mean by filter? Can you give more details, please? Thanks.

There is a clear() in DataSetCache which would clear the cache, adhocEnginServiceImpl.getDataSetCache().clear();

I believe if you want to modify a default property of AdhocUnifiedState, you will most like want to edit WEB--INF/applicationContext-adhoc-.xml. Look for bean id adhocUnifiedStateTemplate in that xml file and add the property that you want to modify. However, this is just the initial property setting, not sure doesn't it work for your case or not. - ivan

Yes, you can turncate JIAccessEvent. In fact, you can configure JasperServer to clean up the JIAccessEvent table periodically. And I believe the default value is the beginning of each month. If yyou want to clean up the table more frequently, you just have to modify the cronEspression value in accessEventPurgerTrigger bean in applicationContext-events-logging.xml. It will delete all the items (which are 60 days old/ older) from JIAccessEvent when this clean up event triggers. If you want to delete items which are less than 60 days old, you can change the value for maxAccessEventAge in accessServiceTarget bean in applicationContext-events-logging.xml. I hope this is going to help. Thanks.