Perform advanced queries on data stored in Azure Tables (DW? MR?) -


we adtech company , store large amount of data in azure tables. things page views, page actions, sessions etc each user. reason chose azure tables on sql server sheer volume of data (tens of thousands every second).

we looking take 1 step further , perform advanced queries on data. somehow possible in azure ecosystem? maybe through loading data in data warehouse offering or through map reduce queries?

in addition, if above possible thinking ingest data in micro-batches in data warehouse make sure have relatively fresh copy , not have load huge batches. azure supports?

thanks

with azure tables can query data using query operators these: https://msdn.microsoft.com/en-us/library/dd135725.aspx build custom application using azure table capabilities deeper analysis.

alternatively, if interested in doing big data analysis data, within azure using existing software framework, consider hdinsight or data lake analytics. offers more sophisticated. hdinsight: https://azure.microsoft.com/en-us/documentation/services/hdinsight/ data lake analytics: https://azure.microsoft.com/en-us/documentation/services/data-lake-analytics/ each analytical engine have means data ingestion.


Comments

Popular posts from this blog

java - Run spring boot application error: Cannot instantiate interface org.springframework.context.ApplicationListener -

reactjs - React router and this.props.children - how to pass state to this.props.children -

Excel VBA "Microsoft Windows Common Controls 6.0 (SP6)" Location Changes -