Search:

Type: Posts; User: craigtrombly

Page 1 of 5 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    9
    Views
    1,711

    The best way to do this it to create a Temp table...

    The best way to do this it to create a Temp table storing the year and the max revision number, then select from that temp table with an inner join on the dimension table.


    CREATE TABLE AllYears...
  2. Replies
    9
    Views
    1,711

    SELECT Taxation_Year, MAX(Amount) AS MaxAmount,...

    SELECT Taxation_Year, MAX(Amount) AS MaxAmount, Parcel_Dimension_Key
    FROM tax_test
    GROUP BY Taxation_Year

    AND I TESTED THIS myself with Infobright & Mysql
  3. Replies
    9
    Views
    1,711

    Do you mean for each year, you want the record...

    Do you mean for each year, you want the record that contains the Highest value for the Sequence Number field. You will always have just one record for each year, but it would be that year with that...
  4. Replies
    9
    Views
    1,711

    SELECT...

    SELECT Parcel_Dimension_Key,Parcel_Key,Taxation_Year,Revision_Sequence,Amount FROM [tablename] WHERE Revision_Sequence = (SELECT MAX(Revision_Sequence) FROM [tablename]);

    Do you mean something...
  5. Optimizing a schema is not a "One size fit all"...

    Optimizing a schema is not a "One size fit all" operation. The details of how you organize your data, store your data and retrieve your data is always going to be done on a individual basis. What I...
  6. Well without know more about the data itself, I...

    Well without know more about the data itself, I am going to reach out to our engineers because I feel that the approach you are taking may have a few drawbacks, but I would like to confirm this...
  7. What is your operating system again? It sounds...

    What is your operating system again? It sounds like you met a limitation on the file system which you did not anticipate. However with as many databases and tables that you have, this is not...
  8. Replies
    16
    Views
    11,538

    What are you asking? The example above does...

    What are you asking?

    The example above does insert the data successfully. Yes I did describe the bhloader binary format, that is the tool that runs when you use LOAD DATA. I thought I covered...
  9. Replies
    16
    Views
    11,538

    Infobright binary format - the structure of...

    Infobright binary format - the structure of binary data files is as follows:

    <row_size><nulls><data_col_1>...<data_col_n>
    ...and then the next data rows, without any separator.

    <row_size> -...
  10. Replies
    16
    Views
    11,538

    My understanding is that does support the...

    My understanding is that does support the varbinary field , but you may have to wrap the data with the HEX() command. Let me track down an example.
  11. Is this thread still open or were you able to get...

    Is this thread still open or were you able to get an answer to your question?
  12. I have also emailed you the ICE 4.0.6 User Guide,...

    I have also emailed you the ICE 4.0.6 User Guide, You should login to the Support Portal for documentation on the User Guide for your version at https://support.infobright.com
  13. I apologize for that oversight ...

    I apologize for that oversight

    https://www.infobright.org/forums/showthread.php?7550-How-to-use-DomainExpert&highlight=domain+expert
  14. You should look into the "Domain Expert" choices...

    You should look into the "Domain Expert" choices listed in your User Guide. Please review this post as well
    ...
  15. Can you please email me a DDL and a small snippet...

    Can you please email me a DDL and a small snippet of your data, just a few lines. And the LOAD DATA statement.

    I would like to run a quick test myself to ensure everything is in order.
  16. This ticket is also being addressed in the...

    This ticket is also being addressed in the helpdesk.....
  17. Try reading through this thread and see if any of...

    Try reading through this thread and see if any of this helps

    https://www.infobright.org/forums/showthread.php?7937-Backup-copy
  18. What version of ICE are you suing? What does the...

    What version of ICE are you suing? What does the version comment say?

    In short yes, ICE is intended to be a single concurrent connection. A second connection can connect to it however it is not...
  19. Yes, you are going to want to Stop the Service...

    Yes, you are going to want to Stop the Service completely. This will flush all disk reads/writes and allow you to do what you need to do next, then Restart the service.

    What is the version...
  20. Replies
    1
    Views
    1,355

    Please post the DDL scripts and email me the...

    Please post the DDL scripts and email me the data, I will send you the script back on how to load.
  21. If you can email me the file and DDL for the...

    If you can email me the file and DDL for the table, I will get the right command with the parameters correct. This happens a lot on windows and I sometimes have to use a hex editor to determine the...
  22. Typically the Newline character LINE TERMINATED...

    Typically the Newline character LINE TERMINATED BY '\r\n\' should be used.

    This usually resolves my issues when going back and forth between Unix & Windows myself OR even using the Windows...
  23. I have yet myself to test it against 2012, but I...

    I have yet myself to test it against 2012, but I cannot imagine why it would not work. I will try right now. You are indicating sysadmin credentials over DBO or SA account?
  24. I am not certain what you are asking. I think...

    I am not certain what you are asking. I think you are asking if ICE locks the table when writing, yes ICE does lock the table during the reading and writing process.
  25. The maybe 2 or 3 people is where your issue may...

    The maybe 2 or 3 people is where your issue may lie. ICE is intended to be single threaded and well as no concurrency. If you have table locks or file reads queues in place while you are attempting...
Results 1 to 25 of 115
Page 1 of 5 1 2 3 4