Hi Sean,   I am sorry for another posting. I found the command to move just 1 table from mysql to hdfs.  But, I am running into one issue   I dropped the table using Hive. But the table still exists in hadoop fs -ls /user/hive/warehouse/ directory.  I tried to delete the file and I don't seem to have the right permissions.  Can you delete this file for me?   Mark ... View more

Hi Sean,   Is there any way I can restore just the Orders HDFS file?  I have been making changes to this table and it looks like I have corrupted it.  I know I need to move the table from mysql database using sqoop. I  would appreciate your reply.   Mark ... View more

Hi Sean,   I resolved the issue with new columns not showing up on the client.  I had to restart Hive and Impala servers.  Now everything shows up.    I dont have any other issues currently.  Thanks for your help.   Mark ... View more

Hi Sean,   I am able to make changes by adding additional columns for date conversion.  It works as designed on the server.  But, for some reason, I am not able to access the new columns from microstrategy.  I also tried to access from a query tool and still the new columns do not show up.  Can you provide any possible reason for the new columns to not show up from the client?   I am thinking of opening a new case as this is a different issue but I could not find the link to create one.   Mark ... View more

Hi Sean,   I am exploring data in the tables and I see order_date as a bigint column in orders table.  When I tried to convert using the function, I don't get the right date format.  I am assuming this is the right function to use.    select from_unixtime(order_date,"yyyy-MM-dd HH:mm:ss.SSSS")from orders   When I run this query, I get data such as   45533-04-18 12:00:00.0000   Please see in my instance and let me know if I am using the right function.   Mark ... View more

Thanks Sean.  I am closing this case.   Mark ... View more

Hi Sean,   All I had to do is to add an entry for inbound (custom tcp - port 21050) and I added ip as 0.0.0.0/0.  This works.  The outbound already has an entry to allow all traffic from all ip addresses and ports.  Do you want me to modify outbound entry to make it very specific?  I am not going to change the outbound defaults.   Please reply when you get a chance.   Mark   ... View more

Hi Sean,   I can now connect through Microstrategy.  Currently, the network is open to all traffic.  I am going to try the secure option next.  I have downloaded and installed Wireshark. Thanks very much for your help.   Mark ... View more

Hi Sean,   Thanks for the input.  I am not good with networking and I would like to first see if I can connect from my machine to the cluster to run reports.  I would like to try with what your are saying here:   "If you don't really care about the security of your cluster, you can also try just opening up the network ACL entirely to see if everything else is working before trying to lock it down again"   Can you tell me how I can do this?  I will test out connectivity and then lock it down.   Please let me know when you get a chance.   Mark ... View more

Hi Sean,   I tried to add an entry (with rule number 130) using custom TCP with port number 21050 to connect to Impala from my local machine using Microstrategy.  It looks like this port is at the instance level.  The network acl id is acl-6348e107 and subnet is subnet-f1987987.  Can you tell me the entries I need to use for opening up access?  I could connect from Putty on my machine to the manager node.   But with Microstrategy, I am trying to connect to one of the worker nodes (as I did with Tableau) using public IP address 54.210.54.84:21050.  This doesn't work.  I would appreciate if you could provide the entries I need to add to get access to Impala from my machine.   Thanks,   Mark ... View more