Hi Brian, Thanks for the information. Ted. ...
Thanks for the information.
I am going through tutorial 1, and the query select * from nyse_stocks where stock_symbol=”IBM” returns no rows. If I view the file via the File Browser, I can see all the data is there. But when I view the nyse_stocks table in HCatalog, it only contains stocks that begin with letter A. So its as though the creation of the table from the file has created a truncated table. All I did was enter the table name and description and select the file (which I verified has all of the stocks in it). On the next page I just accepted the defaults (delimiter of tab), and on the final page for HCatalog I set my columns to the appropriate data types. My “describe nyse_stocks” output matches the tutorial exactly.
Does anyone have any idea what may be causing this strange behavior? I have dropped the table in HCatalog and tried to re-create but I get the same results. I even dropped the file and re-uploaded it. Same result.
You must be logged in to reply to this topic.