Could you please share the steps that resolved the issue and mark as best answer? Thanks, Sindhu ... View more

select TO_DATE(created_at), DATEDIFF(TO_DATE(current_date()), TO_DATE(sales_flat_order.created_at)) as delay, count(*) as NumberOfOrders FROM magentodb.sales_flat_order WHERE status IN ( 'packed' , 'cod_confirmed' ) GROUP BY TO_DATE(created_at), DATEDIFF(TO_DATE(current_date()), TO_DATE(sales_flat_order.created_at)) ... View more

@sameer lail Go to Ambari-> HDFS and search for dfs.datanode.data.dir then go to your Linux server and navigate to respective directories to see the data. Ex: [root@adcp DATA]# pwd /DATA [root@adcpDATA]#ls -lrt drwxr-xr-x. 3 root root 4096 Dec 15 2014 sdd1 drwxr-xr-x. 3 root root 4096 Dec 15 2014 sdc1 drwxr-xr-x. 3 root root 4096 Dec 15 2014 sdf1 drwxr-xr-x. 3 root root 4096 Dec 15 2014 sde1 drwxr-xr-x. 3 root root 4096 Dec 15 2014 sdg1 ... View more

You can try as below li <- read.table(textConnection(c), sep = ","); ... View more